For the record:
Those are the records in my locale.gen
# cat /etc/locale.gen.old
en_US ISO-8859-1
he_IL UTF-8
he_IL ISO-8859-8
I found out that by removing "he_IL ISO-8859-8" i fixed the problem.
Why ? i have no idea ( maybe some collisions because the double he_IL ? ).
Cheers
Michael Ben-Nes wrote:
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
--------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
