Re: No fun with MS Access and Latin1 - Mailing list pgsql-odbc

From Christof Glaser
Subject Re: No fun with MS Access and Latin1
Date
Msg-id AC7011B8-0186-11D9-A294-000A957E650E@gl.aser.de
Whole thread Raw
In response to Re: No fun with MS Access and Latin1  ("Philippe Lang" <philippe.lang@attiksystem.ch>)
Responses Re: Workaround: No fun with MS Access and Latin1
List pgsql-odbc
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


pgsql-odbc by date:

Previous
From: Richard Huxton
Date:
Subject: Re: new to Unixodbc: can't connect to Postgresql
Next
From: Michael Anderson
Date:
Subject: Connection Failure