Re: Convert to character set (upgrading from 4.0 to 4.1)

2005-02-14 Thread Gleb Paharenko
Hello. As said at: http://dev.mysql.com/doc/mysql/en/charset-conversion.html You should avoid trying to convert directly from latin1 to the real character set. If you have a backup, import a table from it. Check that your character_set_xxx variables have a corresponding values. See:

Convert to character set (upgrading from 4.0 to 4.1)

2005-02-11 Thread Eli
Hi.. I encountered some problems with character sets. On the 4.0 version I stored UTF-8 strings. When upgraded to 4.1, I saw the default character set was 'latin1', so I converted to UTF-8 using this: ALTER TABLE my_table CONVERT TO CHARACTER SET 'utf8', DEFAULT CHARACTER SET 'utf8'; When