I'm a novice to mysql and do not have any idea about XML. The database I'm working on has been imported (somehow) form a XML file. Now all special characters are displayed in some kind of code within the database. For example a small e with accent (`) is
Here are my questions:
1. What kind of code is that?
2. is there anyway to replace those characters with the actual special character? [ Otherwise all my cgi-scripts are worthless since they use the user name and definitely need the EXACT spelling of it..]
Can you post examples of these characters as a plain text file on your server somewhere?
Most probably somewhere along the export/import process UTF-8 data got "translated" into ASCII code.
(most XML files are UTF-8)
There are some online sites where you can decode such strings, or at least download character equivalent charts, or you could use a good desktop editor (XML Spy, BBEdit), or write a regex function in PHP. You'd then copy tables (make backups), run the content through the transformer script, and put it back in mySQL again. Depending on the size of your data, PERL might be better suited.
well, the main problem is, that I do not know how to write a script tthat would do this.
And I do not feel like doing a replace for every special character in nearly 6000 records..(even though BBEdit is a great prog.)