Hi Tom,
thanks for reply.
> Perhaps you don't have the database locale/encoding set correctly?
test1=# show server_encoding;
server_encoding
-----------------
UTF8
(1 row)
> (Look at the lc_collate and lc_ctype settings, and compare to what
> you were using in 8.4.)
the 8.4 setup is gone :(
>
> Another possibility is that you changed machines and the new OS
> doesn't have the right Cyrillic locale definition. PG mostly depends
> on the OS' locale features to implement things like case folding.
Here is my locale settings:
~# locale
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE=C
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=
--
Best regards ,
Martin Vassilev
Network/System Administrator
Net-Surf.net Ltd.
phone: + 359 96 399994
e-mail: mv@netsurf.bg
http://www.netsurf.bg