[development] multisite shared table upgrade enhancements (was
what would be more useful)
steven at acko.net
Tue Feb 28 13:42:23 UTC 2006
> Altering the table and columns does not reliably prevent
> foreign characters from being irretrievably mangled.
> If we change tables like this, we also need to change their
No we don't. I follow the exact recommendations from the MySQL
documentation. In the original issue http://drupal.org/node/51110 this
is explained. Drupal has been sending UTF-8 data, but MySQL did not know
this. So it interpreted the data as another character set (e.g.
Latin-1). This meant that character counts and boundaries were off and
that case conversion did not work.
The fix is to force mysql to only re-interpret the data, and not change
it. The underlying bytes remain the same, but MySQL now knows where to
place character boundaries and how to do case conversion the right way.
If your data is corrupted by the update, then it was not in UTF-8 to
More information about the development