Skip site navigation (1) Skip section navigation (2)

JDBC driver should use database encoding

From: Martin Kuba <makub(at)inet(dot)cz>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: JDBC driver should use database encoding
Date: 1999-05-14 15:25:32
Message-ID: 373C406C.D5DCB492@inet.cz (view raw or flat)
Thread:
Lists: pgsql-interfaces
Hi,

Postgres 6.4.2 has multibyte support, so database can be
in one of several encodings. But the JDBC driver uses
for fetching data this method:
 
src/interfaces/jdbc/postgresql/ResultSet.java line 164:
return new String(this_row[columnIndex - 1]);

It means that not the database internal encoding, but 
the default encoding of client JVM will be used for
converting 8-bit characters to 16-bit UNICODE characters.

In postgres 6.5beta is the same code, so I think next
release will have the same bug.

Is it difficult to get the database encoding and use
it for converting bytes to Strings ? Is anybody planning
to do it ? If not, how can I do it ?

Martin
-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
   INET, a.s.                          Mgr. Martin Kuba
Kralovopolska 139                  e-mail: makub(at)inet(dot)cz
  601 12 Brno                      WWW: http://www.inet.cz/~makub/
 Czech Republic                    tel: +420-5-41242414/33
--------------------------------------------------------------------
PGP fingerprint = D8 57 47 E5 36 D2 C1 A1  C3 48 B2 59 00 58 42 27
 http://wwwkeys.cz.pgp.net:11371/pks/lookup?op=index&search=makub
--------------------------------------------------------------------

Responses

pgsql-interfaces by date

Next:From: Rahul Sharma - Tech. Trainee - 97Date: 1999-05-14 15:32:23
Subject: Need Help S.O.S
Previous:From: Kevin LoDate: 1999-05-13 19:29:46
Subject: Re: [INTERFACES] Porting Postgres to NT procedures for English version.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group