Ticket #59 (closed task: fixed)
MySQL character set for UTF-8?
|Reported by:||christoph||Owned by:||astrid|
The standard character set in MySQL for UTF-8 is
where ci means "case insensitive". There are some tables that have keys that are case sensitive: "keyword" for example has an entry "land" and an entry "Land". So importing this dump in MySQL fails.
For ISO8859-1 there is a case sensitive encoding