From: Joerg Bruehe
Date: August 16 2010 10:06am
Subject: Re: Storage of UTF-8 char in MySQL
List-Archive: http://lists.mysql.com/mysql/222534
Message-Id: <4C690DB5.7000506@oracle.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: quoted-printable

Ryan,, all:


Ryan Chan wrote:
> According to this document:
> http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html
>=20
> It said MySQL support UTF-8 using one to three bytes per character.
>=20
> But I have created a test table:
>=20
> -- create table test ( c char(5) ) default charset =3Dutf8;
>=20
> 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=F6rg

--=20
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