Postgres Pro
Downloads
Home   >   mailing lists

Thread: Is UTF-8 required for PostgreSQL JDBC?

Is UTF-8 required for PostgreSQL JDBC?

From
"Wm.A.Stafford"
Date:
When installing PostgreSQL two weeks ago I thought I  read that the
encoding for a DB that will be acccessed via JDBC must be UTF-8.  Is
this correct?  I can not find the docs  page where I saw this and I'm
beginning to wonder if I imagined it.

Thanks in advance,
Bill Stafford

Re: Is UTF-8 required for PostgreSQL JDBC?

From
Roland Walter
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Wm.A.Stafford wrote:
> When installing PostgreSQL two weeks ago I thought I  read that the
> encoding for a DB that will be acccessed via JDBC must be UTF-8.  Is
> this correct?  I can not find the docs  page where I saw this and I'm
> beginning to wonder if I imagined it.
>

You may choose any encoding for your database that PostgreSQL supports.

Regards,
Roland.

- --
Dipl.-Phys. Roland Walter    phone:  +49 2238 462163
Römerfeldstr. 8              mobile: +49 177 2373036
50259 Pulheim                mailto: roland.walter.rwa@gmx.net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFFXnJhxoOEAkary1ERAtIGAJ4nWaX2JZeeDsROwoxEBTbqEVSoHgCfQa1P
jzdJ4z2xcWCvtKjb6zfL2Rw=
=FKUd
-----END PGP SIGNATURE-----

Re: Is UTF-8 required for PostgreSQL JDBC?

From
Markus Schaber
Date:
Hi, Bill,

Wm.A.Stafford wrote:
> When installing PostgreSQL two weeks ago I thought I  read that the
> encoding for a DB that will be acccessed via JDBC must be UTF-8.  Is
> this correct?  I can not find the docs  page where I saw this and I'm
> beginning to wonder if I imagined it.

That's wrong, the database can be in any encoding you like.

The connection actually is encoded in UTF-8. PostgreSQL converts all
data between UTF-8 and the actual database encoding, and the JDBC triver
converts between UTF-8 and the JVM-internal unicode representation
(which is likely to be an UTF-16-derivate, as that's closest to what's
visible to the Java code).

Executing a "SET client_encoding TO foobar" through the JDBC driver may
break things for that one connection.

HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org