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

Migration from odbc driver 7.x to 8.x

From: Christian Schröder <cs(at)deriva(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Migration from odbc driver 7.x to 8.x
Date: 2005-09-06 16:12:09
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Hello list!
We have been using the PostgreSQL odbc driver for a long time 
to access our PostgreSQL 8.0.3 database with Microsoft Access. Now we 
updated to odbc driver and get the well-known problems with  
non-ascii characters. I have already found several threads in this 
mailing list and have come to the conclusion that it has been our fault 
to use an SQL_ASCII encoding in our database. So I set up a test 
database using UNICODE as encoding and tried to store some umlauts in it 
(using the new odbc driver). This worked fine; however, when I tried to 
access this new database using the old odbc driver, the umlauts were not 
displayed correctly.
Now my question is: How can I perform a smooth migration from the old 
odbc driver to the new one? Is there any special trick? If I change the 
database encoding, the old driver will fail to get the umlauts right. If 
I don't change, the new driver does not work. It will be nearly 
impossible to do an instant update of the driver on all computers.
Thanks a lot for your suggestions.


Deriva GmbH                          Tel.: +49 551 50419181
Financial IT and Consulting           Fax:  +49 551 5083159
Hans-Böckler-Straße 2        
D-37079 Göttingen

Deriva CA Certificate:

pgsql-odbc by date

Next:From: Hiroshi SaitoDate: 2005-09-06 16:35:31
Subject: Re: Critical Bug with UseDeclareFetch in development version
Previous:From: Marko RistolaDate: 2005-09-06 14:52:04
Subject: Critical Bug with UseDeclareFetch in development version

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