Unicode conversion issue

From: Al Cohen <amc79(at)no(dot)junk(dot)please(dot)cornell(dot)edu>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Unicode conversion issue
Date: 2004-03-09 03:43:33
Message-ID: T4CcnQ5iFM33oNDdRWPC-w@speakeasy.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

We have a PostgreSQL database in Unicode that I'm trying to read into a
C# application. In theory, the easiest thing to do would be to use the
Beta ODBC Unicode driver or one of the .NET data providers for
PostgreSQL, but these seem to be fairly immature.

So, I'm hoping to use the standard ODBC driver, which seems quite
mature, to read and write to a Unicode database. Can this be done by
properly decoding and encoding?

For starters, I'm wondering if someone can help me to understand just
what the standard psqlODBC is returning to my C# application when I read
a unicode string? The ASCII characters (<128) are returning as ASCII
characters, but the higher characters are turning into 4 unicode
characters, or 8 bytes. My initial thought was that this was UTF-8, but
UTF-8 is maximum 6 bytes.

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message dojie pornea 2004-03-09 12:00:56 Re: Oracle Dev2000 using PostgreSQL as Database
Previous Message Tom Lane 2004-03-08 21:31:23 Re: compiling psqlodbc for unixodbc -- problems