Re: Bug or not about ASCII and Multi-Byte character set - Mailing list pgsql-odbc

From Andreas Pflug
Subject Re: Bug or not about ASCII and Multi-Byte character set
Date
Msg-id 42FF34F2.9010008@pse-consulting.de
Whole thread Raw
In response to Bug or not about ASCII and Multi-Byte character set  ("ZF" <zf.tech@gmail.com>)
List 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

pgsql-odbc by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Updates to page on using psqlodbc with Debian
Next
From: Oliver Elphick
Date:
Subject: Re: Updates to page on using psqlodbc with Debian