Valentine Gogichashvili escribió:
> On 8.2.3 database with LC_CTYPE set to en_EN, lower() function is actually
> corrupting UTF8 data, lowering UTF8 control bytes... I did have a chance to
> check if how it works on the 8.3 as I do not have any db instance with the
> LC_CTYPE set to en_EN.
I don't know about Unicode case mapping, but en_EN is not a UTF8 locale
which is why it's corrupting the data. Try en_EN.utf8 instead.
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2008-07-21 15:09:57|
|Subject: Re: Problem loading ispell affix file with apostrophes |
|Previous:||From: Valentine Gogichashvili||Date: 2008-07-21 11:19:52|
|Subject: BUG #4319: lower()/upper() does not know about UNICODE case mapping|