Re: Unicode, ODBC and MS Access - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: Unicode, ODBC and MS Access
Date
Msg-id 3E54A8D9.E4EDDCEC@tpf.co.jp
Whole thread Raw
In response to Unicode, ODBC and MS Access  ("Marcus Better" <marcus@dactylis.com>)
List pgsql-odbc
Marcus Better wrote:
>
> Hello,
>
> I have some problems which I think have to do with Unicode strings in
> Windows.
>
> Currently, my database is set to Unicode encoding (which I understand means
> UTF-8). I use Windows-based programs (running on .NET) through ODBC to
> insert some text in UCS-2 encoding.
>
> Now when I try to read that data using the same client program, it
> sometimes truncates long strings (after a few hundred characters or so).
>
> Moreover, if I access the same tables using Access XP, in most cases the
> text is garbled. I see only fragments of the text, with garbage characters
> in it, or in some cases no text at all.
>
> What is the correct way to set up a database (with appropriate encoding)
> and ODBC drivers so that Windows programs can read and write Unicode text
> (UCS-2)?

Which driver are you using ?

regards,
Hiroshi Inoue
    http://www.geocities.jp/inocchichichi/psqlodbc/

pgsql-odbc by date:

Previous
From: "Marcus Better"
Date:
Subject: Unicode, ODBC and MS Access
Next
From: "Hiroshi Inoue"
Date:
Subject: Re: Unicode, ODBC and MS Access