Re: ODBC driver types

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Philippe Lang
> Sent: 22 September 2005 10:00
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] ODBC driver types
>
> Hi,
>
> I have seen there are different types of the PGSQL ODBC
> driver v.8 now:
>
> Postgresql ANSI     8.01.0005
> Postgresql Unicode  8.01.0005

From the FAQ (now shipped with the installer):

2.5) There are 2 drivers installed - which should I use?

PostgreSQL Unicode is a Unicode enabled driver that will work well with
modern versions of applications such as Microsoft Access, with character
from a huge range of languages. You should use this driver with
PostgreSQL databases encoded as 'UNICODE' (more precisely known as
'UTF-8' in PostgreSQL).

PostgreSQL ANSI is an ANSI driver which is also able to handle some
multibyte character sets such as EUC_JP, BIG5 and Shift-JIS. This driver
should also be used with databases encoded using any of the LATIN
charactersets.

Note that some applications (notably Borland BDE) do not work properly
with Unicode ODBC drivers. In this case, you must use the ANSI driver.

> Postgresql-libpq    8.01.0004

Lose that one - it's no longer required.

Regards, Dave.