psqlodbc-08_00_0102 and LATIN1 database

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]