PDA

View Full Version : Some characters convert wrong



therapist
Sat 11th Mar '06, 11:32am
Hello,

I am trying to import my forum's database from phpBB 2.0.19 to my new installation of vBulletin 3.5.4.
Everything seems to convert just fine, but I can not get some characters right. These are characters specific for czech language such as "č", "ů", "ř", "ě" and others. After the import, these characters are replaced by "?".

I suppose it's a problem of database tables collations.
My forum is in Czech language and the source database tables (phpBB) collation is cp1250_czech_cs and the default vBulletin tables collation after the installation is latin1_swedish_ci.
Is it possible that the problem is somewhere there?
How to set up things properly to make the import work?

Thanks in advance.

therapist
Sat 11th Mar '06, 12:16pm
I can not use cleaner.php as decribed in the manual because all of those characters are replaced by one character - the question mark "?".

therapist
Sun 12th Mar '06, 2:59am
Both databases are on the same machine.
If I run following SQL query

SHOW VARIABLES LIKE 'char%'
I get these results:

character_set_client utf8
character_set_connection utf8
character_set_database cp1250
character_set_results utf8
character_set_server latin1
character_set_system utf8
character_sets_dir D:\MySQL\share\charsets/
for my source phpBB database
and

character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_results utf8
character_set_server latin1
character_set_system utf8
character_sets_dir D:\MySQL\share\charsets/
for my vBulletin database.

Any help would be much appreciated. I am lost now and can't move. Thanks a lot.