I checked for de_DE.utf8 (created a test database with initdb) and lower/upper is working correctly there on both 8.2 and 8.3 in different languages
On Jul 22, 11:26 am, valgog <[EMAIL PROTECTED]> wrote: > On Jul 21, 4:32 pm, [EMAIL PROTECTED] (Alvaro Herrera) wrote: > > > > > 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 ([EMAIL PROTECTED]) > > To make changes to your > > subscription:http://www.postgresql.org/mailpref/pgsql-bugs > > Will en_EN.utf8 know about German, Russian, Romanian and Dutch? -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs