Re: Matching uppercased russian words (\x0410-\x042F) in UTF8 database 8.4.13 - Mailing list pgsql-general

From Tom Lane
Subject Re: Matching uppercased russian words (\x0410-\x042F) in UTF8 database 8.4.13
Date
Msg-id 1924.1363789242@sss.pgh.pa.us
Whole thread Raw
In response to Re: Matching uppercased russian words (\x0410-\x042F) in UTF8 database 8.4.13  (Alexander Farber <alexander.farber@gmail.com>)
List pgsql-general
Alexander Farber <alexander.farber@gmail.com> writes:
> Thanks for trying! I am using CentOS 6.3
> It seems to be better in 9.2.x?

As stated upthread, 8.4 doesn't understand \u escapes.  You'd need to
put in the characters another way --- either literally, or using octal
escapes to spell out the UTF8 encoding.  I think it will work in 8.4
if you do, but not 100% sure.

            regards, tom lane


pgsql-general by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: Matching uppercased russian words (\x0410-\x042F) in UTF8 database 8.4.13
Next
From: Adrian Klaver
Date:
Subject: Re: File Fragmentation