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 :
is displayed in Access as :
exter (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
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
pgsql-odbc by date
|Next:||From: Marko Ristola||Date: 2005-08-11 19:36:28|
|Subject: Re: [ODBC] PG 7.3.4 VS PG 8.0.3 Problem|
|Previous:||From: Ankur kashyap||Date: 2005-08-11 10:09:40|
|Subject: ODBC Problem|