Topic: Charset on PunBB, 1.2.15 vs MySQL 5.6
First of all, thank you for this forum and to read my request.
I apologize for the possible english mistakes, this is not my native language, i'm French (it also happens to good people ).
Also, I'm really sorry to bring back this section from the dead, but i need help. I hope i don't post in the bad section... If so, please apologize me.
Here's my case :
I have an old PunBB, 1.2.15 version related to a website, with a long story (10 years up), a community involved, etc. You can find it here.
For many reason, i have to migrate all my hosting (website + board) on a new server, with MySQL 5.6.
So i've installed a new board, but i'd like to keep archives from the old one, in a read only mode.
You can see this installation here (not in read only for the moment)
I had multiple problems, but i have corrected many of them. However, i'm stuck with 2 lasts bugs related to charset (i believe so).
The first one is about special characters, like é, è, ê, à, etc. When they came from my DB, all these characters appears like this : �
The second one is the post message doesn't appears when you consult a topic. The message block is empty. But i've noticed the message appears when i do a search. You can see example here : empty topic & search results.
So it means that the problem for the "empty message" does not provide from my DB.
I've been on many websites, i've been reading a lot, but i don't find the solution.
I've converted all my files in UTF-8 Format.
I've fully converted my DataBase in utf8_general_mysql500_ci for the "collations" parameter.
I've added <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> in all my files.
And many other stuffs stuffs to resolve previous problems (before these actions, all the messages were truncated after the first special character as "é" "à" "œ", etc.)
Does any one of you has an idea to help me ?