[ psqlodbc-Bugs-1000796 ] client encoding mismatch using ANSI driver with ANSI app

Bugs item #1000796, was opened at 2006-12-04 16:50
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10007 96&group_id=1000125

Category: None
Group: None
>Status: Closed
Resolution: None
Priority: 3
Submitted By: Farid Zidan (faridz)
Assigned to: Hiroshi Inoue (hinoue)
Summary: client encoding mismatch using ANSI driver with ANSI app

Initial Comment:
My application is an ANSI application. If I try to connect using PostgreSQL ANSI 8.02.02.00 driver I get the following error:

SQL Error. Error: 214, SQLState: HY019, Return Code: -1
client encoding mismatch

Strangley enough, I am able to connect using PostgreSQL Unicode 8.02.02.00 version of the driver with no error.



------------------------------------------------------------ ----------

Comment By: Farid Zidan (faridz)
Date: 2006-12-08 08:59

Message:
This now works. Thanks.

------------------------------------------------------------ ----------

Comment By: Hiroshi Inoue (hinoue)
Date: 2006-12-07 14:42

Message:
Oops please try the attached ANSI driver.

------------------------------------------------------------ ----------

Comment By: Hiroshi Inoue (hinoue)
Date: 2006-12-06 16:41

Message:
Please try the attached dll.

regards,
Hiroshi Inoue

------------------------------------------------------------ ----------

Comment By: Farid Zidan (faridz)
Date: 2006-12-05 00:50

Message:
Note: database encoding is WIN1252

------------------------------------------------------------ ----------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10007 96&group_id=1000125

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match