Обсуждение: support

hi,pgsql-genera

    I am chinese user, I have installed thd PostGreSQL 8.0 for win in my computer, it's very good.
but I find a problem, when I use "select * from dcvalue where text_value='中文'" to search record, 
the system return "no results", moreover when I use "select * from dcvalue where text_value like '中文'" 
to search record, the system return "1 record". I have checked the text_value, it's length equal 4.
can you tell me why and how to do.
    thanks very much.

    

　　　　　　　　致
礼！
                 

　　　　　　　　金更达
　　　　　　　　jgd@lib.zju.edu.cn
　　　　　　　　　　2004-11-20

金更达 wrote:

>hi,pgsql-genera
>
>    I am chinese user, I have installed thd PostGreSQL 8.0 for win in my computer, it's very good.
>but I find a problem, when I use "select * from dcvalue where text_value='中文'" to search record,
>the system return "no results",
>
seems like your locale setting doesn't match to your database encoding.
you should use EUC_CN or unicode as your database encoding and zh_CN.utf8
as your locale setting.

regards

laser