Hi,
I am having problem migrating a arabic vbulletin database from a remote server to my server, as it shows strange characters , or what we call charset or encoding issue and I have not been able to get past and fix it. On my server ################ mysql> show variables like 'char%' ; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+ 8 rows in set (0.00 sec) mysql> mysql> mysql> show variables like 'colla%' ; +----------------------+-------------------+ | Variable_name | Value | +----------------------+-------------------+ | collation_connection | latin1_swedish_ci | | collation_database | latin1_swedish_ci | | collation_server | latin1_swedish_ci | +----------------------+-------------------+ 3 rows in set (0.00 sec) mysql> mysql> On remote sever, I have phpmyadmin acess to the database in arabic. When I take a back of the database using phpMyAdmin , I infact see strange characters in the backup sql file itself. Please advise Thanks
