Re: Bug or not about ASCII and Multi-Byte character set

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: ZF <zf(dot)tech(at)gmail(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Bug or not about ASCII and Multi-Byte character set
Date: 2005-08-14 12:11:30
Message-ID: 42FF34F2.9010008@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

ZF wrote:
> version: psqlodbc 08.00.0101 and 08.00.0102
>
> The server database encoding is ASCII in win2000. After inserting
> several multi-byte characters with pgAdmin3(version: 1.2.1),

Since SQL_ASCII is *not* multi-byte, pgAdmin will insert single byte
characters which are non-ASCII compliant. You can't read such data with
unicode. Simple advice: don't use SQL_ASCII for storing non-ASCII data.
Use a specific encoding or Unicode.

Regards,
Andreas

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Oliver Elphick 2005-08-14 17:36:01 Re: Updates to page on using psqlodbc with Debian
Previous Message Peter Eisentraut 2005-08-14 10:44:02 Re: Updates to page on using psqlodbc with Debian