Thread: How to store chinese using the Postgresql?

How to store chinese using the Postgresql?

From
"Timothy Chan"
Date:
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

Re: How to store chinese using the Postgresql?

From
"Shridhar Daithankar"
Date:
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?

ByeShridhar

--
"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)



Re: How to store chinese using the Postgresql?

From
Tatsuo Ishii
Date:
>     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