From: | Christopher Gillin <crgillin(at)yahoo(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Encoding Issues |
Date: | 2005-11-05 03:17:02 |
Message-ID: | 20051105031702.10263.qmail@web53905.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hello,
My current setup is a PostgreSQL server (7.4.5)
running on RH 9, a database with UNICODE character set
and trying to connect using Windows ODBC Manager with
Postgres driver (8.01.00.05).
I'm using the UNICODE version of the driver to
retrieve some UTF8 characters form the database. The
problem is, in some stage of the SQLGetData it's
trying to do a conversion and breaking the character.
In both of the following cases I SET_CLIENT ENCODING
TO 'UNICODE'. This is from mylog_****.log
[3552][SQLGetData][3552]PGAPI_GetData: enter,
stmt=4140704
[3552] num_rows = 1
[3552] value = 'ä'
[3552]**** PGAPI_GetData: icol = 0, fCType = 1,
field_type = 1043, value = 'ä'
[3552]copy_and_convert: field_type = 1043, fctype = 1,
value = 'ä', cbValueMax=1000
[3552]DEFAULT: len = 1, ptr = '�?'
[3552] SQL_C_CHAR, default: len = 1, cbValueMax =
1000, rgbValueBindRow = '�'
Using the ANSI version of the driver I don't encounter
this problem
[2788][SQLGetData][2788]PGAPI_GetData: enter,
stmt=4140528
[2788] num_rows = 1
[2788] value = 'ä'
[2788]**** PGAPI_GetData: icol = 0, fCType = 1,
field_type = 1043, value = 'ä'
[2788]copy_and_convert: field_type = 1043, fctype = 1,
value = 'ä', cbValueMax=1000
[2788]DEFAULT: len = 2, ptr = 'ä'
[2788] SQL_C_CHAR, default: len = 2, cbValueMax =
1000, rgbValueBindRow = 'ä'
Does anyone know why this wouldn't work with the
UNICODE version of the PostgreSQL driver?
__________________________________
Start your day with Yahoo! - Make it your home page!
http://www.yahoo.com/r/hs
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2005-11-05 08:32:59 | Re: newbie: excel connection? other ad-hoc query windows client? |
Previous Message | Joshua D. Drake | 2005-11-05 02:33:03 | Re: newbie: excel connection? other ad-hoc query windows client? |