Re: Testing unicode Characters in mySQL 5.0.3 beta
Posted by: vick
Date: May 06, 2005 11:21AM

Let me reply my own questions
A) It is good idea to have the collation to utf8_unicode_ci so change step 1 as

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

In step B do not give any escape or hex sequence, but the character itself as

INSERT INTO test_unicode values('礙於本文件級與授權更動');
INSERT INTO test_unicode values('A');

Note:Do not use Query Browser to add above statements. Use phpMyAdmin or save in a text file with
utf8 encoded.

In step C do not use Query Browser or mysql utility to verify the results, use phpMyAdmin to verify
SELECT * from test_unicode;

Options: ReplyQuote

Written By
Re: Testing unicode Characters in mySQL 5.0.3 beta
May 06, 2005 11:21AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.