pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Charsets in JDBC driver?
3+ messages / 2 participants
[nested] [flat]

* Charsets in JDBC driver?
@ 2000-05-23 10:05  Anders Bengtsson <anders@natakademin.se>
  0 siblings, 0 replies; 3+ messages in thread

From: Anders Bengtsson @ 2000-05-23 10:05 UTC (permalink / raw)
  To: pgsql-interfaces

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?

/Anders
________________________________________________________________________
A n d e r s  B e n g t s s o n                     anders@natakademin.se
http://www.natakademin.se/



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* RE: Charsets in JDBC driver?
@ 2000-05-23 10:24  Peter Mount <petermount@it.maidstone.gov.uk>
  0 siblings, 1 reply; 3+ messages in thread

From: Peter Mount @ 2000-05-23 10:24 UTC (permalink / raw)
  To: 'Anders Bengtsson' <anders@natakademin.se>; pgsql-interfaces

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?

/Anders
________________________________________________________________________
A n d e r s  B e n g t s s o n                     anders@natakademin.se
http://www.natakademin.se/



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Charsets in JDBC driver?
@ 2000-05-23 11:49  Anders Bengtsson <anders@natakademin.se>
  parent: Peter Mount <petermount@it.maidstone.gov.uk>
  0 siblings, 0 replies; 3+ messages in thread

From: Anders Bengtsson @ 2000-05-23 11:49 UTC (permalink / raw)
  To: Peter Mount <petermount@it.maidstone.gov.uk>; pgsql-interfaces

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/



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2000-05-23 11:49 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-05-23 10:05 Charsets in JDBC driver? Anders Bengtsson <anders@natakademin.se>
2000-05-23 10:24 RE: Charsets in JDBC driver? Peter Mount <petermount@it.maidstone.gov.uk>
2000-05-23 11:49 ` Anders Bengtsson <anders@natakademin.se>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox