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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
