Urdu contents changed to ??? (Question marks) after importing to webhost

  • Hello,

    I’ve setup a website on my pc using localhost which also include few posts and pages in Urdu language. Then I migrated to webhost by uploading files, exporting and then importing mysql database. Whole website runs fine expect Urdu contents. Ask pages/post with Urdu are converted to question marks.

    While exporting the database, I used all value set by default except compression.

Viewing 2 replies - 1 through 2 (of 2 total)

  • This is an issue with Encoding, which phpmyadmin refers to as “Character set of the file”.

    You must export and import with the same Encoding. You can also run into problems if the database tables do not correctly specify the “Collation” as phpmyadmin calls it. WordPress prefers Collation to be utf8mb4_unicode_ci

    Admittedly, I have no experience with non-English character sets, so there may be other issues, but I would start with re-doing the export and import, making sure that the Encoding matches.

    “You must export and import with the same Encoding.” UTF8 is recommended.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Urdu contents changed to ??? (Question marks) after importing to webhost’ is closed to new replies.

Tags