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