Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group