Message-ID: <392A7062.D2C57A8E@natakademin.se>
Date: Tue, 23 May 2000 13:49:54 +0200
From: Anders Bengtsson <anders@natakademin.se>
Organization: =?iso-8859-1?Q?N=E4takademin?= AB
MIME-Version: 1.0
To: Peter Mount <petermount@it.maidstone.gov.uk>,
	pgsql-interfaces@postgresql.org
Subject: Re: Charsets in JDBC driver?
References: 
 <1B3D5E532D18D311861A00600865478CF1AE2D@exchange1.nt.maidstone.gov.uk>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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@natakademin.se]
> Sent: Tuesday, May 23, 2000 11:06 AM
> To: pgsql-interfaces@postgresql.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@natakademin.se
http://www.natakademin.se/