Re: Storage of UTF-8 char in MySQL

2010-08-16 Thread Werner Van Belle
Ryan Chan wrote: 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,

Re: Storage of UTF-8 char in MySQL

2010-08-16 Thread Joerg Bruehe
Ryan,, all: Ryan Chan wrote: 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

Storage of UTF-8 char in MySQL

2010-08-14 Thread Ryan Chan
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