[ psqlodbc-Bugs-1000968 ] Unicode driver does not work with multibyte database name
От | |
---|---|
Тема | [ psqlodbc-Bugs-1000968 ] Unicode driver does not work with multibyte database name |
Дата | |
Msg-id | 20070108070729.C5F59216D28@pgfoundry.org обсуждение исходный текст |
Список | pgsql-odbc |
Bugs item #1000968, was opened at 2006-12-21 09:43 You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000968&group_id=1000125 Category: None Group: None >Status: Closed Resolution: None Priority: 3 Submitted By: Nobody (None) Assigned to: Nobody (None) Summary: Unicode driver does not work with multibyte database name Initial Comment: I can't connect multibyte-named database, with PqslODBC 8.02.02.02 and PostgreSQL 8.2. When connecting with Unicode Driver, 'celinet_encoding' option was seted to 'UTF-8'. but database name got by 'SQLGetPrivateProfileString' that's not a Unicode Function, then connInfo->database was encoded with ANSI (such as CP932). Therfore, failed to connection. I think that Unicode Driver should use Unicode version function for Installer API's, and when connecting, convert strings to UTF8 encoding. Excuse my broken english. Regards. ---------------------------------------------------------------------- Comment By: Nobody (None) Date: 2006-12-22 01:59 Message: Thanks for yuor answer,It has been convinced. I think, hex format is not acceptable for average PC users, and it's slightly worthless.I personaly believe that If Unicode driver support utf8 encoded connection options, that's corresond to default client_encoding, it's worthy. Please close this bug. Regards. ---------------------------------------------------------------------- Comment By: Hiroshi Inoue (hinoue) Date: 2006-12-22 00:21 Message: I don't think PostgreSQL is supposed to support multibyte database/user name and I'm not inclined to implement your proposal trusting to luck. Well how about allowing to use hex format database name ? regards, Hiroshi Inoue ---------------------------------------------------------------------- Comment By: Nobody (None) Date: 2006-12-21 13:32 Message: Thaks for replying. Also with ANSI driver, I can't connect. I'm using UTF-8 database encoding. By PostgreSQL's sources, database name was compared with strings in "data/global/pg_database". Databasae name was not affected any conversion while connecting.In the file, database name was written with the encoding of the database which running "create database" SQL. If "create database" run on "EUC_JP/UTF-8" encoding database, then database name recorded by "EUC_JP/UTF-8" encoding.I saw it's mixed in same file. Perhaps,general solution is only adding 'database name encoding' setting on odbc config and convert database name to that encoding on connecting. at least, i hope to support UTF-8 encoding. Regards. ---------------------------------------------------------------------- Comment By: Hiroshi Inoue (hinoue) Date: 2006-12-21 11:04 Message: Can you connect to the databse using ANSI driver ? What's your database encoding ? regards, Hiroshi Inoue ---------------------------------------------------------------------- You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000968&group_id=1000125
В списке pgsql-odbc по дате отправления: