Can anyone help to fix the following problem :

I am using Mysql version 4.017 & odbc 3.51.06 under window 2000 environment, the client is window98.
It seems not work when I was using Full-Text Search function with Chinese Character. How can I do ? Thanks!

I have to admit I'm not suprised ... when you add the odbc layer on top of my SQL that's another level of obfurscation above using the client directly, and then you start getting involved with unicodes an the rest too ...

Welcome to the board;  I can give you a sanity check and tell you that, no, you're not going mad and have missed an answer that everyone knows.  In fact, I'm rather afraid that your question is rather too specific for most of us here.  Here's hoping that one of the other poster can come up with something, but please don't hold your breath

Try using MySQL v4.1. I believe v4.0 doesn't support Unicode.

I am also doing the same thing, exept with Japanese Kana and Kanji, using MySQL and PHP.

Also it depends on the encoding you are using. Full-text search depends on indexing words, right? It finds words by separating data using spaces and punctuation, but this is a problem in Asian scripts as these criteria for distinguishing words simply do not apply (like in Japanese, where spaces are not used.)

Back to the encoding. UTF-8 is a good choice, as it preserves the 'standard' spaces in the encoding (however this is not true for a full-width space used in Japanese).

---