Thread:Project:Support desk/Pagetitle encoding eroblems when upgrading a wiki/reply

Hi!

I have once fixed that kind of error; it is a tidysome work. :-(

The result, which you must have in the end is: Your database uses UTF-8 or binary encoding and the data in your database is (in any case) UTF-8-encoded.

First you need to know what kind of encoding your system uses:
 * What is the encoding of the database, of the different tables and of all columns, which have an encoding (that means of columns holding "text" and so on as opposed to "integers")?
 * Are all these encodings identical?
 * They should all be either "utf8_general_ci" or "binary" - and all the same.


 * What you see in the screenshot is that the data in the column, which you posted, does in fact not use the encoding, which you provide as "encoding declaration" for that column.
 * So what you need to do is: If the column's content in fact is already UTF-8 encoded, then convert the encoding declaration for that column (not the content in it!) to UTF-8. That worked in some way by temporarily making the column a BLOB, then converting it (MySQL does not change the content of blobs when you convert the charset) and then set the column back to the type it had before.
 * If the content in the column in fact is not UTF-8-encoded, you need to convert the encoding of the content to UTF-8. I think that worked same as above, but without changing the affected columns to blob before.

I know there also are some scripts around