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; >

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

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