psqlodbc-08_00_0102 and LATIN1 database

From: Laurent Constantin <laurent(dot)constantin(at)aql(dot)fr>
To: pgsql-odbc(at)postgresql(dot)org
Subject: psqlodbc-08_00_0102 and LATIN1 database
Date: 2005-08-11 13:00:44
Message-ID: 42FB4BFC.2030300@aql.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hello,

A character encoding error arises with psqlodbc-08_00_0102. It was ok
with psqlodbc-08_00_0101. By switching files psqlodbc.dll of both
versions, problem appears/disappears, so I'm almost sure some change
between 0101 and 0102 causes the error.

I have a LATIN1 database :
# psql -l
List of databases
Name | Owner | Encoding
-----------+--------+-----------
vulne | abcd | LATIN1
# psql --version
psql (PostgreSQL) 8.0.3

I use a French (latin1, ISO-8859-1) version of Access 2000.

In the way PostgreSQL ==> Access :
With version 0102, characters are converted from LATIN1 to unicode.
So, all my French accent characters, stored in the database, "eats"
following letters. For example :
exécuter
is displayed in Access as :
ex[]ter (the [] means a black box)
In the way Access ==> Postgresql :
With version 0102, caracters are converted from unicode to LATIN1.
So, if I enter a French accent in Access, a strange char is stored
in PostgreSQL.

There is no error message.

Attached, you'll find log files.

In order to work, I reinstalled psqlodbc-08_00_0101, so you don't have
to hurry for me :). However, this is a blocking problem if I want to
install a future version of psqlodbc.

Don't hesitate to contact me. I am at your disposal to test any dll you
may send to me.

PS: I couldn't find the changelog to see what kind of change could have
caused this.

Thanks,

Regards,
Laurent Constantin
--
laurent(dot)constantin(at)aql(dot)fr [principal/main]
http://www.laurentconstantin.com/ [principal/main]
laurentconstantin(at)free(dot)fr [secondaire/backup]
http://go.to/laurentconstantin/ [secondaire/backup]
http://laurentconstantin.est-la.com/ [secondaire/backup]

Attachment Content-Type Size
psqlodbc_956.log text/plain 1.0 KB
mylog_956.log text/plain 6.8 KB

Browse pgsql-odbc by date

  From Date Subject
Next Message Marko Ristola 2005-08-11 19:36:28 Re: [ODBC] PG 7.3.4 VS PG 8.0.3 Problem
Previous Message Ankur kashyap 2005-08-11 10:09:40 ODBC Problem