> Tatsuo,
>
> recently I tried to understand why I can't get sorting works properly
> with cyrillic characters in UTF8 datbase. I figure out the
> reason of my confusion - I thought I could specify different encodings
> for different databases and these encodings will be used in text operations
> (sort, upper,lower), not just for conversion.
> But, actually, the only encoding is important for text operations - the one
> specified with 'initdb' command ! Is't true ?
>
> If so, it's a big issue :)
>
> After I created separate storage for unicode (initdb -E utf8) and
> restarted postmaster I got success with 'order by', but
> upper(), lower() functions still fails.
[I assume you enable the locale support.]
Dont't ask me. These are locale support problems.
--
Tatsuo Ishii
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
