Обсуждение: MBC user cannot connect to server
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 withMultibyte character username. I have added "useUnicode=true and characterEncoding=UTF8" when i try to make the connectionby calling DriverManager.getConnection(url, props).. any suggestions? BTW, i m using postgresl-8.1-405.jdbc3.jaras my driver. TIA, Yu _________________________________________________________________ Use Messenger to talk to your IM friends, even those on Yahoo! http://ideas.live.com/programpage.aspx?versionId=7adb59de-a857-45ba-81cc-685ee3e858fe
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 notwith 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
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 All, > > > > I am using postgresql V8 and can connect to the db from my java program using username only consists of ASCII, but notwith 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 _________________________________________________________________ All-in-one security and maintenance for your PC. Get a free 90-day trial! http://www.windowsonecare.com/purchase/trial.aspx?sc_cid=wl_wlmail
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
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: > > 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 _________________________________________________________________ Express yourself with gadgets on Windows Live Spaces http://discoverspaces.live.com?source=hmtag1&loc=us