From: | Michael Ben-Nes <miki(at)canaan(dot)co(dot)il> |
---|---|
To: | postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: The server's LC_CTYPE locale |
Date: | 2006-09-05 11:56:21 |
Message-ID: | 44FD65E5.1090403@canaan.co.il |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
--------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | gustavo halperin | 2006-09-05 11:57:27 | Re: Porting from ORACLE to PostgSQL |
Previous Message | aBBISh | 2006-09-05 11:25:17 | how to add postgresql service by command on windows |