List:General Discussion« Previous MessageNext Message »
From:Joerg Bruehe Date:August 16 2010 10:06am
Subject:Re: Storage of UTF-8 char in MySQL
View as plain text  
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 the table status, the data length is alway a multiple of 16.

When you have a question about any software behavior (not limited to
MySQL), you really should specify the version and the platform.

No, we won't guess.


Jörg

-- 
Joerg Bruehe,  MySQL Build Team,  joerg.bruehe@stripped
ORACLE Deutschland B.V. & Co. KG,   Komturstrasse 18a,   D-12099 Berlin
Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven
Amtsgericht Muenchen: HRA 95603

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