Обсуждение: 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/
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/
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/