So Dev

Very puzzled about a Unicode problem on MySQL 5.0.18

I encounted something very strange about MySQL 5.0.18 when dealing with Unicode. I use a Unicode capable client called NaviCat to enter Unicode data into a table. I access the same database using my home computer and my office computer. In fact that whole database (including all bin and everything) are on the exact same removable harddisk. The character of a test table is in "utf8 - UTF-8 UNicode" and Collation is "utf8-general-ci".

Since I access the same database with the same engine on the same harddisk both at my home and in office, I should see the exact same data, right? Well, turns out something wasn't right.

And I kind of suspect that it could have something to do with NaviCat.

Well, let me explain the problem first. In order to test Unicode, I entered Traditioanl Chinese, Japanese and Simplified Chinese character on a testing table I mentioned before. Here's the strange result: I can see all three kinds of character at home for the data I entered at home. I can see all three kinds of character in the office for the data I entered in the office. But I CANNOT see the data I entered at home in the office, and vice verse. Very strange.

I way I see it, since I use everything exactly maybe the OS environment, so maybe there's somethig to do with the OS, but... they are both XP...

Oh well, I have other junk to do. Guess I'll mess with this when I have time later.

posted by Deecay @ 10:44 AM