Re: ODBC & character encoding
| От | Iain |
|---|---|
| Тема | Re: ODBC & character encoding |
| Дата | |
| Msg-id | 001301c50ce7$6a23ffd0$7201a8c0@mst1x5r347kymb обсуждение исходный текст |
| Ответ на | ODBC & character encoding ("Layet Benjamin" <benjamin@moonfactory.co.jp>) |
| Список | pgsql-odbc |
Hi,
I havn't dne much with unicode on a PG database yet, so this is just a guess (albeit an educated one based on what i read in the docs)
Maybe you need to use "set client_encoding to 'UNICODE'" as there didn't appear to be a UTF8 encoding as such.
refer to section 20.2.1 of the 7.4 manual: http://www.postgresql.org/docs/7.4/interactive/multibyte.html - don't think this has changed since 7.1, but you should check it.
regards
Iain
----- Original Message -----From: Layet BenjaminSent: Monday, February 07, 2005 4:04 PMSubject: [ODBC] ODBC & character encodingHi,I am trying to run a query from .Net C# using ODBC on a Postgres 7.1 Database.The database encoding is EUC_JP.And as I use .Net the default encoding is UTF8.My problem is that the 7.1 version does not support to set the client encoding to UTF8 :Here is the ODBC error log:<code>[ Client encoding = 'EUC_JP' (code = 1) ]
conn=105462528, query='set client_encoding to 'UTF8''
ERROR from backend during send_query: 'ERROR: Client encoding UTF8 is not supported'</code>So when I insert Data, the japanese characters don't appear properly....The database is running for a production server and I cannot stop the service at all... Not to mention upgrading...So my question is :- Can the ODBC driver convert the query string from UTF8 to EUC_JP before sending it to the database server ?and how ?I hope you understand my problem and my question...Any help would be extremely appreciated,Benjamin
В списке pgsql-odbc по дате отправления: