My preferred character set is utf8. One big drawback in many cases can be that the default collation ignores accents for characters. The result is that "halla"

Altering the character set and collation of a table is sometimes not enough. You may have to alter the actual fields in the table to get MySQL to comply in some

When altering a database, table or field from one character set to another, existing data will probably look garbled since it is expected to be in the new chara