Re: A JDBC bug or problem relating to string length in Java

On Mon, 1 Sep 2003, joe user wrote:

>
> --- Kris Jurka <books@ejurka.com> wrote:
> > You did not mention what your server encoding is.  I
> > assumed it was
> > unicode, but could you confirm this?
>
> You mean the Postgres server?  I don't know.  I never
> set it.  This is a plain-vanilla installation of
> RedHat 9, and I downloaded and compiled plain-vanilla
> PG 7.3.4, so whatever the default encoding would be,
> that is what I'm using.  For the Java runtime, I'm
> also using the plain-vanilla defaults under Redhat 9.
> Is there a way to find out?

SELECT datname,pg_encoding_to_char(encoding) FROM pg_database;

Kris Jurka