JDBC Support for standard_conforming_strings - Mailing list pgsql-jdbc

From Michael Paesold
Subject JDBC Support for standard_conforming_strings
Date
Msg-id 454E4DA7.8030603@gmx.at
Whole thread Raw
Responses Re: JDBC Support for standard_conforming_strings
List pgsql-jdbc
Hi all,

Regarding standard_conforming_strings, I am currently reading through
the code and looking at all places that need to understand string
escaping rules.

I have found two issues where I need more advice:

arrays (org.postgresql.jdbc2.AbstractJdbc2Array)
bytea (org.postgresql.util.PGbytea)

As far as I understand, quoting in arrays and bytea only changes as far
as the types are passing through the backend parser as string-literals.
Correct?

Since the result of AbstractJdbc2Array.toString() and
PGbytea.toPGString() will be fed to PreparedStatement.setString() in the
end, we do not have to change the array or bytea code. Is this reasoning
valid?

Best Regards,
Michael Paesold

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Enhancement: toBoolean() and empty String
Next
From: Michael Paesold
Date:
Subject: [PATCH] Escaping of SAVEPOINT names