| Christopher Gillin 2005-11-05, 3:23 am |
| 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]& #91;3552]PGAPI_GetDa
ta: enter,
stmt=4140704
[3552] num_rows = 1
[3552] value = 'ä'
[3552]**** PGAPI_GetData: icol = 0, fCType = 1,
field_type = 1043, value = 'ä'
& #91;3552]copy_and_co
nvert: 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]& #91;2788]PGAPI_GetDa
ta: enter,
stmt=4140528
[2788] num_rows = 1
[2788] value = 'ä'
[2788]**** PGAPI_GetData: icol = 0, fCType = 1,
field_type = 1043, value = 'ä'
& #91;2788]copy_and_co
nvert: 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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
|