Jiang Sheng writes:
> In your opinion, should I re-compile the PostgreSQL after set the $LANG
> to ja_JP.utf8? or I need to set other variables' value..
Recompiling has nothing to do with that. Please see the Administrator's
Guide chapter on localization for all the information.
--
Peter Eisen
- Original Message -
送信者 : "Peter Eisentraut" <[EMAIL PROTECTED]>
宛先 : "Jiang Sheng" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
送信日時 : 2002年11月18日 6:21
件名 : Re: [BUGS] Different result when using '=' and 'like' in unicode mode
> Jia
Jiang Sheng writes:
> the sql is
> select * from tbl_test where name = '石田';
>
> but the result contains other data, such as 石町, 柳町, 柳田
>
> and I changed the sql to
> select * from tbl_test where name like '石田';
> select * from tbl_test where name ilike '石田';
>
> the results both correct.
The LIK
