MS Access, Unicode, Conversions & Foreign languages characters

From: "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch>
To: "PostgreSQL ODBC" <pgsql-odbc(at)postgresql(dot)org>
Subject: MS Access, Unicode, Conversions & Foreign languages characters
Date: 2003-11-16 13:24:19
Message-ID: 6C0CF58A187DA5479245E0830AF84F420AF7BB@poweredge.attiksystem.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hello,

Did anyone find a solution to the problem of foreign languages character encoding, when data is accessed through MS Access 2000? Characters with accents appear correctly in PG Admin 3.0, but not when they go through ODBC.

I have read different things on the subject: The drivers supports Unicode UTF-9, but Access requires Unicode UCS-2, for example.

Is there a workaround, for example by forcing a special encoding when doing a "CREATE DATABASE", or by using a "CREATE CONVERSION"?

I'm using the latest driver.

Thanks

-------------------------
Philippe Lang
Attik System
http://www.attiksystem.ch

Browse pgsql-odbc by date

  From Date Subject
Next Message Wolfgang Meiners 2003-11-16 15:09:23 installation of odbc
Previous Message Shachar Shemesh 2003-11-15 17:55:51 Extreme slowness