pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Martin Kuba <makub@inet.cz>
To: pgsql-interfaces@postgresql.org
Subject: JDBC driver should use database encoding
Date: Fri, 14 May 1999 17:25:32 +0200
Message-ID: <373C406C.D5DCB492@inet.cz> (raw)

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@inet.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
--------------------------------------------------------------------



view thread (4+ messages)  latest in thread

Message-ID: <373C406C.D5DCB492@inet.cz>
Permalink:  ../373C406C.D5DCB492@inet.cz/
Also on:    postgresql.org/message-id/373C406C.D5DCB492@inet.cz

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: makub@inet.cz
  Subject: Re: JDBC driver should use database encoding
  In-Reply-To: <373C406C.D5DCB492@inet.cz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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