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

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 (view raw or flat)
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: mylog_956.log
Description: text/plain (6.8 KB)
Attachment: psqlodbc_956.log
Description: text/plain (1.0 KB)

pgsql-odbc by date

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

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