Replace diacritics SQL, PHP?

Replace diacritics SQL, PHP?

Just download your sql database, open the file with notepad++ (it is a free software that runs very fast for such tasks) and with find and replace, replace all the diacritics with normal characters.

You can then ignore after that the sql tables are in latin1 format.

This is helpful for Romanian diacritics for example, it is much easier and faster than running a script that will replace characters troughout the database.

Add a comment: