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.

Thanks,

Brad

7 Nov 2003 14:26:15 -0800
bradclark_98@yahoo.com (Brad)
Setting client encoding with jdbc


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


Sun, 9 Nov 2003 20:59:02 -0500 (EST)
Kris Jurka <books@ejurka.com>
Re: Setting client encoding with jdbc