The server's LC_CTYPE locale

[Michael Ben-Nes <miki(at)canaan(dot)co(dot)il>]

Hello


Im got the following error when the query string was one of the Hebrew 
chars:


SELECT upper('ש');
ERROR: invalid multibyte character for locale
HINT: The server's LC_CTYPE locale is probably incompatible with the 
database encoding.


after few minutes while gathering info i stoped getting the previous 
error and started to get:


#SELECT lower('ש');
ERROR:  invalid UTF-8 byte sequence detected near byte 0xf9

# SELECT upper('ש');
ERROR:  invalid UTF-8 byte sequence detected near byte 0xf9


#SELECT version();
PostgreSQL 8.1.3 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.3 
(Debian 4.0.3-1)


#show lc_ctype ;
he_IL.utf8


#SHOW SERVER_ENCODING;
UTF8

Any ideas what the problem ?


--

--------------------------------------------------
Michael Ben-Nes - Internet Consultant and Director.
http://www.epoch.co.il - weaving the Net.
Cellular: 054-4848113
--------------------------------------------------