Olivier Mascia escreveu:

> Adriano,
>
> To close this subject, can you confirm me that the engine actually=20=20
> stores an utf8 string of bytes when the database or at least the=20=20
> object like a column is declared UTF8 ? So a 'a' takes one byte of=20=20
> storage, a '=E9' two and so on (string compression put aside of course) ?
>

Yes.

> Speaking of string compression, if I'm not mistaken 'aaaaaaaaaaaaaa'=20=20
> makes good use of the string compression mechanism when stored. But=20=20
> what about '=E9=E9=E9=E9=E9=E9=E9=E9=E9=E9=E9=E9=E9=E9' stored in UTF8? Do=
> es the string=20=20
> compression still makes its magic or is it killed by the encoding?
>

AFAIU, the engine doesn't compress such strings, unfortunately.


Adriano