Oliver Jowett <oliver(at)opencloud(dot)com> writes:
> Tom Lane wrote:
>> At a guess, the name of the database will have to be in UTF8. I doubt
>> that JDBC will think it should do any character set conversion on it.
> Has something changed here so that non-7-bit data in the startup packet
> will work?
The server just thinks those are 8-bit strings. I guess my
recommendation is that you should go ahead and send UTF8, and if the
user created the non-ASCII name that way, it'll work. (In practice I
think that means he'd have to issue the CREATE DATABASE or CREATE USER
command while logged into a database that uses UTF8 encoding.)
This whole business of per-database encodings is a mess, of course.
regards, tom lane
In response to
pgsql-jdbc by date
|Next:||From: Albe Laurenz||Date: 2007-10-24 07:18:07|
|Subject: Re: "Something unusual has occured" error using PostgreSQL 8.2 with Apache Commons DBCP 1.2.2|
|Previous:||From: Oliver Jowett||Date: 2007-10-23 23:15:17|
|Subject: Re: Chinese database name in URL, can I ?|