Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: BUG #4319: lower()/upper() does not know about UNICODE case 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 UNICODE case mapping
- Date: Mon, 21 Jul 2008 10:32:57 -0400
- Message-id: <20080721143257.GB5842@alvh.no-ip.org> <text/plain>
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.
- Follow-Ups:
- References:
- BUG #4319: lower()/upper() does not know about UNICODE case mapping
- From: Valentine Gogichashvili
- BUG #4319: lower()/upper() does not know about UNICODE case mapping
- Prev by Date: BUG #4319: lower()/upper() does not know about UNICODE case mapping
- Next by Date: Re: Problem loading ispell affix file with apostrophes
- Previous by thread: BUG #4319: lower()/upper() does not know about UNICODE case mapping
- Next by thread: Re: BUG #4319: lower()/upper() does not know about UNICODE case mapping
- Indexes: