UNICODE driver vs ANSI Driver - Mailing list pgsql-odbc

From Barry Bell
Subject UNICODE driver vs ANSI Driver
Date
Msg-id 4D51A19E0157604B94159573456A98FA2E799458@BLUPRD0811MB413.namprd08.prod.outlook.com
Whole thread Raw
List pgsql-odbc
Hi:
   What is the difference between the windows ODBC PostgresSQL ANSI driver and the Unicode Driver?

When using the ANSI driver with a date type bind variable, we get a UTF-8 conversion error for some dates (Dates like
01/01/2010,01/04/2010) but not for others."ERROR: character with byte sequence 0xc2 0x9d in encoding "UTF8" has no
equivalentin encoding WIN1252" 

We do not get this error with UNICODE driver.

Any ideas what is happening?
Any issues with using the UNICODE driver instead of ANSI?

Thanks





pgsql-odbc by date:

Previous
From: Andres Freund
Date:
Subject: Re: [HACKERS] getting rid of SnapshotNow
Next
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] getting rid of SnapshotNow