Skip site navigation (1) Skip section navigation (2)

Re: No fun with MS Access and Latin1

From: Christof Glaser <gcg(at)gl(dot)aser(dot)de>
To: "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: No fun with MS Access and Latin1
Date: 2004-09-08 11:03:11
Message-ID: AC7011B8-0186-11D9-A294-000A957E650E@gl.aser.de (view raw or flat)
Thread:
Lists: 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


In response to

Responses

pgsql-odbc by date

Next:From: Michael AndersonDate: 2004-09-08 17:51:35
Subject: Connection Failure
Previous:From: Richard HuxtonDate: 2004-09-08 07:22:06
Subject: Re: new to Unixodbc: can't connect to Postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group