Mysql Collation

From Fxp Wiki

Error : conflict collation

Solution: you have to change collation, not only on the connection, the database, the table, but also on the columns. Therefore, in dlp and semantic wiki, you have sometimes to change the collation of the column page_title in the page table.

... but this make another mysql error:

#1062 - Duplicate entry '0-lang' for key 2 

The solution for this is simply to DROP INDEXES linking with these columns.

Date: Jul/12/08