Special characters in my database after moving to a new host

  • Resolved su1

    (@su1)


    12 years, 9 months ago

    Hello,

    after moving my site and database to a new host, I got special characters in my database (problem of encoding probably).

    For example instead of “Bébert” I get “Bébert”.

    I have opened the exported .sql file and the correct characters are present, so I guess it’s a problem during the upload? But my file is encoded in utf8 and I set up PhPMyadmin to upload an utf8 file, so I don’t know what’s going on.

    Any ideas?

    Thanks.

    Edit: old server version is 5.0.92. New server version is 5.0.91. That’s the only difference I’ve found so far.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter su1

    (@su1)

    12 years, 9 months ago

    up please I need your help

    Thread Starter su1

    (@su1)

    12 years, 9 months ago

    Problem solved.
    One of the tables in my sql file had the parameter

    DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

    all the other tables were in utf8 though.

    Just uploading this latin1 table alone after the others should resolve the problem (if it can help others)

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Special characters in my database after moving to a new host’ is closed to new replies.