Testing unicode Characters in mySQL 5.0.3 beta
Posted by: vick
Date: April 27, 2005 05:12PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Testing unicode Characters in mySQL 5.0.3 beta
3313
April 27, 2005 05:12PM


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.