List:General Discussion« Previous MessageNext Message »
From:Ryan Chan Date:August 14 2010 2:28pm
Subject:Storage of UTF-8 char in MySQL
View as plain text  
According to this document:
http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html

It said MySQL support UTF-8 using one to three bytes per character.

But I have created a test table:

-- create table test ( c char(5) ) default charset =utf8;

From the table status, the data length is alway a multiple of 16.

So how does it support 3 byte UTF-8 in practice?


Thanks
Thread
Storage of UTF-8 char in MySQLRyan Chan14 Aug
  • Re: Storage of UTF-8 char in MySQLWerner Van Belle16 Aug
  • Re: Storage of UTF-8 char in MySQLJoerg Bruehe16 Aug