Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group