Log in

View Full Version : missing latin characters


snoop1979
11-20-2007, 03:02 AM
i am changing host provider so i made a dump with phpmyadmin then restored using bigdump on the new server, also upload all php files.
forum work but characters like ? ? ? ? has been replace for weird characters, how can i fix this? or where is the problem in the dump? restoration?, i noticed on the original host all the tables are latin1_swedish_ci and after import they seem to be the same (latin1_swedish_ci) on the new server, what it could be? :confused:

--------------- Added 1195535358 at 1195535358 ---------------

"?" its been replaced by "ñ" also just noticed that on the old host phpmyadmin all tables show 33.8 MB on the new server shows 48.4mb

--------------- Added 1195537302 at 1195537302 ---------------

fixed!
restored using phpmyadmin and selection utf-8 on import

snakes1100
11-20-2007, 01:29 PM
This is generally caused by the host mysql server having the wrong charset running on the server you imported it into, check the following mysql variables

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