Re: ODBC driver types - Mailing list pgsql-odbc

From Dave Page
Subject Re: ODBC driver types
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E4CC2E0E@ratbert.vale-housing.co.uk
Whole thread Raw
In response to ODBC driver types  ("Philippe Lang" <philippe.lang@attiksystem.ch>)
Responses Re: ODBC driver types  (Håkon Clausen <hakonhc@hclausen.net>)
Re: ODBC driver types  (Håkon Clausen <hakonhc@hclausen.net>)
List pgsql-odbc

> -----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.

pgsql-odbc by date:

Previous
From: "Philippe Lang"
Date:
Subject: ODBC driver types
Next
From: "Dave Page"
Date:
Subject: Re: client encoding mismatch