On 7 Nov 2003, Brad wrote:
> I'm interested in changing the client encoding from within a java > program. I'm using connection pooling and need to change it depending > on the client's language preference. Is there a function I can call > which changes the client encoding. Something like > > pStmt = con.prepareStatement("select > pg_set_client_encoding('LATIN5'); "); > rs = pStmt.executeQuery(); > > I can set the client encoding from within psql by /encoding LATIN5 but > not sure how to execute something like this from java. Any help would > be greatly appreciated. > Please direct JDBC questions to the pgsql-jdbc list. You may not set the client encoding from JDBC. The JDBC driver requires a unicode client encoding to work properly. You may then reencode the data in your charset of preference using the standard java APIs. Kris Jurka ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html