lower('Å') or upper('å') gives improper results.
Hi,
Please find the output of the simple query :
sfa_db=> select upper('å');
upper
-------
å
(1 row)
PostGRESql doesn't convert the special characters like Å, Ò, etc into their lower case when using function lower and vice-versa when using upper.
Neha
Neha Kasat writes:
PostGRESql doesn't convert the special characters like ￜ, ￜ, etc into
their lower case when using function lower and vice-versa when using
upper.
It does if you select the right locale.
--
Peter Eisentraut peter_e@gmx.net
Peter Eisentraut <peter_e@gmx.net> writes:
Neha Kasat writes:
PostGRESql doesn't convert the special characters like �, �, etc into
their lower case when using function lower and vice-versa when using
upper.
It does if you select the right locale.
... and character set. We don't have support for this yet in multibyte
character sets (like Unicode). You need to pick an appropriate ISOnnnn
encoding and a suitable locale setting.
regards, tom lane