Re: No fun with MS Access and Latin1

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.

Thanks and best regards,

Christof

Best regards,

Christof Glaser
--
-- gl.aser . software engineering . internet service
-- Doelitzer Strasse 37 . D-04277 Leipzig . fon +49-341-303 20 51
-- http://gl.aser.de/ . sms +49-177-779 28 43 . fax +49-341-303 20 52