Re: Charsets in JDBC driver?

Ok, using "\l" in psql shows that my databases has "SQL_ASCII" as
charset. Is there some way to determine that setting for a database
through the driver interface? I guess that would make it possible to
implement a complete support for charsets in the JDBC driver.

Or, in other words, is the driver protocol defined somewhere? :)

/Anders

Peter Mount wrote:
>
> Currently, the driver does little with Unicode. This is mainly because I
> don't have much dealings with any other encodings than the standard, so
> it's difficult to test.
>
> Peter
>
> --
> Peter Mount
> Enterprise Support
> Maidstone Borough Council
> Any views stated are my own, and not those of Maidstone Borough Council.
>
> -----Original Message-----
> From: Anders Bengtsson [mailto:anders(at)natakademin(dot)se]
> Sent: Tuesday, May 23, 2000 11:06 AM
> To: pgsql-interfaces(at)postgresql(dot)org
> Subject: [INTERFACES] Charsets in JDBC driver?
>
> Hello,
>
> I'm trying to find out how the JDBC driver handles different character
> encodings, since i'll possibly need have strings in English, Swedish and
> Chinese in the same database and the same Java VM.
>
> Postgres seems to handle a lot of different charsets, both single- and
> multi-byte. Java is all Unicode inside, so there shouldn't be a problem
> there.
>
> I've been looking through the source of the JDBC2 driver, without
> finding much mentioned about character encodings. Does the driver just
> assume that both PostgreSQL and Java are running in the same locale,
> with the same default character encoding?

________________________________________________________________________
A n d e r s B e n g t s s o n anders(at)natakademin(dot)se
http://www.natakademin.se/