PostgreSQL JDBC - MBC user cannot connect to server

Author

MBC user cannot connect to server

zhyu 86

2006-10-25, 8:24 am

Hi All,

I am using postgresql V8 and can connect to the db from my java program using username only consists of ASCII, but not with Multibyte character username. I have added "useUnicode=true and characterEncoding=UT
F8" when i try to make the connection by callin
g DriverManager.getConnection(url, props).. any suggestions? BTW, i m using postgresl-8.1-405.jdbc3.jar as my driver.

TIA,
Yu
____________________
____________________
____________________
_____
Use Messenger to talk to your IM friends, even those on Yahoo!
http://ideas.live.com/programpage.a...cc-685ee3e858fe
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Oliver Jowett

2006-10-25, 8:24 am

zhyu 86 wrote:
> Hi All,
>
> I am using postgresql V8 and can connect to the db from my java program using username only consists of ASCII, but not with Multibyte character username.

Hi

Previous discussion with the backend developers seemed to indicate that
you can't safely use non-ASCII database names or user names. There's no
provision in the startup protocol for identifying the encoding of the
database name & user name provided.

-O

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

zhyu 86

2006-10-25, 8:24 am

I see. Thanks. Any plan to support this in near future? Thanks.

----------------------------------------
> Date: Fri, 13 Oct 2006 12:30:36 +1300
> From: oliver@opencloud.com
> To: zhyu86@hotmail.com
> CC: pgsql-jdbc@postgresql.org
> Subject: Re: [JDBC] MBC user cannot connect to server
>
> zhyu 86 wrote:
>
> Hi
>
> Previous discussion with the backend developers seemed to indicate that
> you can't safely use non-ASCII database names or user names. There's no
> provision in the startup protocol for identifying the encoding of the
> database name & user name provided.
>
> -O
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org

____________________
____________________
____________________
_____
All-in-one security and maintenance for your PC._ Get a free 90-day trial!
http://www.windowsonecare.com/purch...c_cid=wl_wlmail
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Tom Lane

2006-10-25, 8:24 am

zhyu 86 <zhyu86@hotmail.com> writes:
> I see. Thanks. Any plan to support this in near future? Thanks.

AFAIK it'll work as long as you consistently use the same encoding for
the user or database name ... which pretty much means it has to be UTF8
if you are talking to it from Java.

There are no plans to support encoding conversion during authentication.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

zhyu 86

2006-10-25, 8:24 am

Thanks a lot. I appreciate it. Do you happen to know is this apply to other databases as well? (Sybase, Mysql etc)?

----------------------------------------
> To: zhyu86@hotmail.com
> CC: oliver@opencloud.com; pgsql-jdbc@postgresql.org
> Subject: Re: [JDBC] MBC user cannot connect to server
> Date: Thu, 12 Oct 2006 21:56:37 -0400
> From: tgl@sss.pgh.pa.us
>
> zhyu 86 <zhyu86@hotmail.com> writes:
>
> AFAIK it'll work as long as you consistently use the same encoding for
> the user or database name ... which pretty much means it has to be UTF8
> if you are talking to it from Java.
>
> There are no plans to support encoding conversion during authentication.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

____________________
____________________
____________________
_____
Express yourself with gadgets on Windows Live Spaces
http://discoverspaces.live.com?source=hmtag1&loc=us
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Sponsored Links