Testing unicode Characters in mySQL 5.0.3 beta

[vick]

Dear All,

Does anyone know how to do a simple test to accept a unicode character in a table and display it
using mySql Query browser or mysql utility.

I did these but no luck:

A) Create a test table like

CREATE TABLE test_unicode(
unicode-text varhchar(50)) type=innodb default character set utf8;

B) Insert some unicode texts

INSERT INTO test_unicode values('0x0041');
INSERT INTO test_unicode values('\\u0041');
INSERT INTO test_unicode values(')');

C) Fire query using query browser

SELECT * from test_unicode;

Result:

I see the same value as
0x0041
\u0041
&#0041

instead of A

Does anyone know how to test this unicode characters and how mySQL wants to have the unicode characters.

As a side note, I am going to use mySQL table to store Japanese, Korean, Chinese characters.