• 0

MySql database messed-up...


Question

Hey guys. I have a problem with a mysql database for a website. This site is using diacritics (like ă, â, î, ş, etc.) since it's in Romanian, and everything was working fine till it was time to change the host. The admin exported the database (either from cpanel or from phpmyadmin, I don't know exactly) and all the files, but when he imported it to the new sql server, every character on the website was messed up, instead of diacritics it shows weird characters (like ă instead of ă). I thought it was a collation problem (if I open the exported database it says latin1_general_ci), but no matter what I choose, it doesn't fix it. I also tried importing the file via Bigdump, no luck... Is there anything else I can do? There is a LOT of text and manually changing it to the right way is really out of the question... Oh yeah, and there's no access to the original host anymore, so there's nothing I can try there...

Link to comment
https://www.neowin.net/forum/topic/1269048-mysql-database-messed-up/
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Hey TDT,

Would you be able to open up your .sql into a text editor and show a small screenshot snippet of where the characters are different? Also, please say which text editor that you're using.

It'll help look into this, having something to actually look at. :)

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.