Announcement

Collapse
No announcement yet.

Some characters convert wrong

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Some characters convert wrong

    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.

  • #2
    I can not use cleaner.php as decribed in the manual because all of those characters are replaced by one character - the question mark "?".

    Comment


    • #3
      Both databases are on the same machine.
      If I run following SQL query
      Code:
      SHOW VARIABLES LIKE 'char%'
      I get these results:
      Code:
      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
      Code:
      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.

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X