Re: ODBC & character encoding - Mailing list pgsql-odbc

----- Original Message -----

From: Iain

To: Layet Benjamin ; pgsql-odbc@postgresql.org

Sent: Monday, February 07, 2005 5:31 PM

Subject: Re: [ODBC] ODBC & character encoding

Hi Benjamin,

 

I don't have direct experience of your exact situation, but I use a 7.1 database via ODBC. The difference is that the client is not unicode, it's plain old windows shift-JIS and that works fine iff you use the unicode support odbc driver. When you install the postgres ODBC driver it actually contains 3 drivers, which one are you using?

 

> Can the ODBC driver convert the query string from UTF8 to EUC_JP before sending it to the database server ?

 

I'm not sure...

 

> Can the ODBC driver take EUC_JP string as input ? (then I would 'just' have to figure out how to send EUC_JP stings from C#...) 

 

I dunno about that either, but it certainly accepts shift-JIS which is the native encoding for windows.

 

So far I've never had to pay much attention to client encoding (with the notable exception of getting input data from a web application) as the clients and drivers seem to work everything out by themselves.

 

Regards

Iain

 

 

----- Original Message -----

From: Layet Benjamin

To: Iain ; pgsql-odbc@postgresql.org

Sent: Monday, February 07, 2005 5:06 PM

Subject: Re: [ODBC] ODBC & character encoding

Hi,

Thank you Iain for your quick reply.

But unfortunately this did not solve the problem, 7.1 does not support this conversion neither yet. (7.3 and 7.4 do):

 

SET client_encoding='UNICODE';
ERROR:  Conversion between UNICODE and EUC_JP is not supported

 

In theory, I have 3 possible places to convert UTF8 to EUC_JP:

- 1 inside postgres

- 2 inside ODBC

- 3 inside C#

 

 

1

 

        C#                                    ODBC                 Postgres 7.1
Utf8                  l =============>  l                l =====>l UTF8->EUC_JP
(possible->Unicode)   l     UTF8        l                l UTF8  l
______________________l  (or Unicode)   l________________l       l_______________

 

 

2

        C#                                    ODBC                 Postgres 7.1
Utf8                  l =============>  l UTF8->EUC_JP   l =====>l
(possible->Unicode)   l     UTF8        l                l EUC_JPl
______________________l  (or Unicode)   l________________l       l_______________

 

 

3

        C#                                    ODBC                 Postgres 7.1
UTF8->EUC_JP          l =============>  l                l =====>l
(possible->Unicode)   l     EUC_JP      l                l EUC_JPl
______________________l                 l________________l       l_______________

 

 

Number 1 seem to be the normal solution, but it does not work with 7.1.

I would like to know if number 2 or 3 are possible:

so,

 - Can the ODBC driver convert the query string from UTF8 to EUC_JP before sending it to the database server ?

or

- Can the ODBC driver take EUC_JP string as input ? (then I would 'just' have to figure out how to send EUC_JP stings from C#...) 

 

Help extremely needed...

Thank you !

 

Benjamin