Are BOTH the client and server using utf8?
Is the client application using a unicode font that supports the characters you're using? Most fonts only support a subset of unicode characters.
Are you using MySQL 4.1.1?
Do a "SHOW FULL COLUMNS FROM vocab;" to be sure that the columns are using utf8.
Try selecting the hex value of the columns to see if the values are being stored and transmitted properly:
SELECT hex(japanese) FROM vocab;
And remember that the utf8 hex value will not be the same as the unicode code points. To see the code points you can do this:
SELECT hex(convert(japanese using ucs2)) FROM vocab;
If you're testing in xterm with the mysql client be sure that it is set up for unicode and is using a proper font too. And do \s from the mysql client to see the server and client character sets being used.
Good luck,
Jeremy
_________________________________________________________________
Get reliable dial-up Internet access now with our limited-time introductory offer. http://join.msn.com/?page=dept/dialup
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
