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

Re: [INTERFACES] JDBC driver should use database encoding

From: Peter T Mount <peter(at)retep(dot)org(dot)uk>
To: Martin Kuba <makub(at)inet(dot)cz>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [INTERFACES] JDBC driver should use database encoding
Date: 1999-05-17 20:28:32
Message-ID: Pine.LNX.4.04.9905172125320.3493-100000@maidast.retep.org.uk (view raw or flat)
Thread:
Lists: pgsql-interfaces
On Fri, 14 May 1999, Martin Kuba wrote:

> 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 ?

Guess what, I've just found a patch someone sent me earlier in the year,
implementing some Unicode support. If I get chance, I'll take a look at
it, but I don't think I'll get it into 6.5.

Peter

-- 
       Peter T Mount peter(at)retep(dot)org(dot)uk
      Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
 Java PDF Generator: http://www.retep.org.uk/pdf


In response to

pgsql-interfaces by date

Next:From: Peter T MountDate: 1999-05-17 23:02:51
Subject: JDBC Driver
Previous:From: Jackson, DeJuanDate: 1999-05-17 18:45:15
Subject: RE: [INTERFACES] Vacuum takes for ever

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