Subject: Re: Question about encoding
From: Peter Eisentraut <peter_e@gmx.net>
To: Denis BUCHER <dbucherml@hsolutions.ch>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <4A92C305.2020303@hsolutions.ch>
References: <4A92C305.2020303@hsolutions.ch>
Content-Type: text/plain; charset="UTF-8"
Date: Tue, 25 Aug 2009 01:42:25 +0300
Message-Id: <1251153745.29824.19.camel@vanquo.pezone.net>
Mime-Version: 1.0
Content-Transfer-Encoding: 8bit

On mån, 2009-08-24 at 18:42 +0200, Denis BUCHER wrote:
> Question 1 :
> Is it the expected behavior ? These characters have a SQL_ASCII
> equivalent because I already have them stored in another table of the
> same database

SQL_ASCII is not the same as ASCII.  SQL_ASCII means, take the bytes as
they come.  So a 40-character UTF-8 string might indeed be longer than
40 bytes, which is what SQL_ASCII will look at.

The best bet is to avoid SQL_ASCII altogether.  It's pretty bogus and
inconsistent.

> Question 2 :
> If yes, then I suppose I should have the database as LATIN1 or UTF8.
> Can I change/convert the encoding of the database ? Or at least of the
> schema (which would be even better)

Dump, recreate database with right encoding, restore.