Re: Can't select/inserting/updating some Chinese Character.
Posted by: jennyzhiliu
Date: December 05, 2005 11:58PM

Hello there,

I am having problem pull out the data with gb2312 also. I inserted the data with gb2312 charset, I can pull out the whole column ok using 'select name from name_table;' , but when I do search using:

select name from name_table where match (name) against ('$query');

where name is fulltext index. I could not get anything back (empty set). where $query is the input I got from a web html FORM input. fulltext index works ok with my english columns. My table is created with latin1 character set and the gb2312 column was later changed to gb2312 using:
alter table name_table modify name varchar(255) character set gb2312

Any ideas why?

Thank you very much for any help.


Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.