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

Re: BUG #4319: lower()/upper() does not know about UNICODEcase mapping

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Valentine Gogichashvili <valgog(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4319: lower()/upper() does not know about UNICODEcase mapping
Date: 2008-07-21 14:32:57
Message-ID: 20080721143257.GB5842@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2008-07-21 15:09:57
Subject: Re: Problem loading ispell affix file with apostrophes
Previous:From: Valentine GogichashviliDate: 2008-07-21 11:19:52
Subject: BUG #4319: lower()/upper() does not know about UNICODE case mapping

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