Weiping <[EMAIL PROTECTED]> writes:
> we have a database which encoding is UNICODE,
> when we do queries like:
> select upper('ÖÐÎÄ'); --select some multibyte character,
> then postgresql response:
> ERROR: invalid multibyte character for locale
What locale did you initdb in? The most likely explanation for this
is that the LC_CTYPE setting is not unicode-compatible.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
