Question [SOLVED] maybe utf8 problem ?

Hello,

I've imported phpbb3 tables into kunena forum following PHPBB3_to_Kunena .
but special characters are not displayed correctly.

all tables created have this option in the import so It must not be a problem:
A picture is better to see my problem :
in forum :
in mysql :

I've searched through this forum and google without success.
could you help me please.

You need to say which encoding you are going to use do the database before you start conversion in your script (otherwise it uses default, which is usually LATIN1).

You also need to be careful that all your string translations in PHP are UTF8 safe.

Thanks for your answer.
It seems to be a problem on the server (ubuntu Linux 10.04b2 under virtualbox).

I've tested the migration on another server (Gentoo Linux) and the problem is no more on It.

Actually it's a problem in the script -- it should specify encoding for MySQL, otherwise it uses default one. Well default is easy to change from my.cnf..

Hello,

You're right, the problem was a mysql configuration proble :huh:
I've set the my.cnf, restarted mysql and everything seems pretty good now :laugh:

thanks for everything