Re: Workaround: No fun with MS Access and Latin1

Replying myself: Latin1 characters work when using the ODBC library
version 7.3.200 with the "Postgresql" driver. The Server log does not
show "set client_encoding to 'utf8'" anymore, everything works fine now.

The Legacy and Unicode drivers give an ODBC error, they don't even connect
to the backend (no connection logged).

7.3.209, 7.5.001, 7.5.002 (from the PG 8 Beta1 MSI) seem to fail
converting Latin1 to/from Unicode correctly when sending SQL commands to
the backend. Perhaps this is also the reason why primary keys on
varchar fields did not work? I'll try that again now with the older
ODBC lib.

Thanks Philippe for pointing me in the right direction.

Best regards,

Christof

On Wed, Sep 08, 2004 at 01:03:11PM +0200, Christof Glaser wrote:
> Hello Philippe,
>
> Am 08.09.2004 um 08:21 schrieb Philippe Lang:
>
> >Hello Christof,
> >
> >What ODBC driver are you using?
> >
> >There are 3 drivers: Postgresql, Postgresql Legacy, Postgresql Unicode.
>
> I'm not so sure, but I think it is called 'Postgresql' as I remember
> seeing this option somewhere in the ODBC dialogs.
> There were no other options to choose from.
>
> The servers' log file shows me "select pg_client_encoding()" and
> directly after "set client_encoding to 'UTF8'", hence I assume it is a
> Unicode version. I'm currently not at the Windows machine, but I could
> send logfile snippets later, if necessary.
>
> >I'm using the first one "Postgresql", (snapshot 208 or 209), with
> >Access 2000, 2002 or 2003 without any problem. I haven't tried Access
> >97.
> >
> >My databases are encoded in LATIN1 as well, for French. Update with
> >accents are fine, at least with PGSQL 7.3.x and 7.4.x.
>
> Sound good. Does your server also run on Windows (cygwin)?
>
> Perhaps I give 7.4. a try on cygwin, that's easier than switching to a
> newer Access version.
--
gl.aser . software engineering . internet service
Dölitzer Straße 37 . 04277 Leipzig . http://gl.aser.de
fon 0341.303 20 51 . fax 0341.303 20 52 . sms 0177.779 28 43
PHP . Lisp . C++ . HTML . SQL . LaTeX . Linux . Mac . WinCC