Re: Can't select/inserting/updating some Chinese Character.

[jennyzhiliu]

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.

Jenny