JDBC Support for standard_conforming_strings

From: Michael Paesold <mpaesold(at)gmx(dot)at>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: JDBC Support for standard_conforming_strings
Date: 2006-11-05 20:46:31
Message-ID: 454E4DA7.8030603@gmx.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Michael Paesold 2006-11-05 21:18:44 [PATCH] Escaping of SAVEPOINT names
Previous Message Kris Jurka 2006-11-05 07:45:25 Re: Enhancement: toBoolean() and empty String