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

Re: JDBC driver patch for non-ASCII users

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, sulfinu(at)gmail(dot)com, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JDBC driver patch for non-ASCII users
Date: 2007-12-08 20:58:23
Message-ID: 475B056F.2040401@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Kris Jurka wrote:

> For the record, I'm in favor of changing our use of initial setup 
> encoding from US-ASCII to UTF-8.  While it doesn't solve the root of 
> the problem, it does allow people to use non-ascii user and database 
> names if they set them up appropriately and doesn't seem to harm 
> anything.

That does seem like the simplest approach and should cover all possible 
usernames (if you can't represent it in UTF-8 you can't get it into a 
String, anyway), if not all possible encodings.

> The original patch's suggested use of the client's 
> environment encoding seems random to me.

Agreed. I don't like the idea of "configure the server to use UTF-8 like 
this.. except if you have one of these encodings as your JVM default in 
which case you need to do something else like this.. and maybe how your 
cluster needs to be configured will change if you change JVM versions or 
environment or driver version".

-O

In response to

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2007-12-08 21:44:18
Subject: Re: JDBC driver patch for non-ASCII users
Previous:From: Oliver JowettDate: 2007-12-08 20:54:19
Subject: Re: JDBC driver patch for non-ASCII users

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