From: | "Iain" <iain(at)mst(dot)co(dot)jp> |
---|---|
To: | "Layet Benjamin" <benjamin(at)moonfactory(dot)co(dot)jp>, <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: ODBC & character encoding |
Date: | 2005-02-07 07:34:05 |
Message-ID: | 001301c50ce7$6a23ffd0$7201a8c0@mst1x5r347kymb |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 Benjamin
To: pgsql-odbc(at)postgresql(dot)org
Sent: Monday, February 07, 2005 4:04 PM
Subject: [ODBC] ODBC & character encoding
Hi,
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
From | Date | Subject | |
---|---|---|---|
Next Message | Layet Benjamin | 2005-02-07 08:06:30 | Re: ODBC & character encoding |
Previous Message | Layet Benjamin | 2005-02-07 07:04:07 | ODBC & character encoding |