| Lists: | pgsql-hackers |
|---|
| From: | "Timothy Chan" <timtimccy(at)hotmail(dot)com> |
|---|---|
| To: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | How to store chinese using the Postgresql? |
| Date: | 2002-10-26 17:23:55 |
| Message-ID: | OE39g0cmGX8w2Gn5Iuc000037df@hotmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Hi
i would like to use postgresql to store any data (some include chinese), but when i access the chinese data in postgresql, i can't get back correct data, it return any unknow word/data to me.
How can i solve it? i am using the RedHat Linux 7.2 and Postgresql 7.1, and i haven't install CLE on Linux.
Thanks
Tim
| From: | "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in> |
|---|---|
| To: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: How to store chinese using the Postgresql? |
| Date: | 2002-10-28 14:01:54 |
| Message-ID: | 3DBD90AA.24453.D9D5A@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On 27 Oct 2032 at 0:24, Timothy Chan wrote:
>
> Hi
> i would like to use postgresql to store any data (some include chinese),
> but when i access the chinese data inpostgresql, i can't get back correct
> data, it return any unknow word/data to me.
> How can i solve it? i am using the RedHat Linux 7.2 and Postgresql 7.1, and i
> haven't install CLE on Linux.
You might have done this but just confirrming, did you use initdb -E to enable
proper locale?
Bye
Shridhar
--
"I would rather spend 10 hours reading someone else's source code than10
minutes listening to Musak waiting for technical support which isn't."(By Dr.
Greg Wettstein, Roger Maris Cancer Center)
| From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
|---|---|
| To: | timtimccy(at)hotmail(dot)com |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: How to store chinese using the Postgresql? |
| Date: | 2002-10-28 14:21:43 |
| Message-ID: | 20021028.232143.45508822.t-ishii@sra.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
> i would like to use postgresql to store any data (some include chinese), but when i access the chinese data in postgresql, i can't get back correct data, it return any unknow word/data to me.
> How can i solve it? i am using the RedHat Linux 7.2 and Postgresql 7.1, and i haven't install CLE on Linux.
Define "chinese." What character set for Chinese are you using?
--
Tatsuo Ishii