UNICODE driver vs ANSI Driver

From: Barry Bell <Barry_Bell(at)harte-hanks(dot)com>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: UNICODE driver vs ANSI Driver
Date: 2013-07-18 16:16:01
Message-ID: 4D51A19E0157604B94159573456A98FA2E799458@BLUPRD0811MB413.namprd08.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 equivalent in 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

Browse pgsql-odbc by date

  From Date Subject
Next Message Alvaro Herrera 2013-07-18 16:25:08 Re: [HACKERS] getting rid of SnapshotNow
Previous Message Andres Freund 2013-07-18 16:08:46 Re: [ODBC] getting rid of SnapshotNow