Re: [BUGS] Different result when using '=' and 'like' in unicode mode

2002-11-17 Thread Jiang Sheng
Thanks a lot! 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.. I changed the $LANG value, but the result still not correct, and not found anything about it in PostgrSQL's document. Thx Jiang Sheng

[BUGS] Different result when using '=' and 'like' in unicode mode

2002-11-16 Thread Jiang Sheng
like '石田'; the results both correct. I don't know the reason of this problem, and in my application it not allowed to use 'like' replaced '=', the data amount is too large. Is this a bug of PostgreSQL? or only a problem in redhat environment? and how to