[GENERAL] PostgreSQL

[Eugeny Balakhonov]

Hello, all!   I have a good question for PostgreSQL FAQ.   How to use string functions (like UPPER()/LOWER()) for non-latin strings? Why UPPER() function doesn't work with my UNICODE PostgreSQL database which contains non-latin characters (like cyrillic)? How to make case insensetive search by text field which contains non-latin characters?   Thanks for your answers!   Best regards Eugeny