groupbrand Posted November 21, 2011 Share Posted November 21, 2011 My client has an old application that did not clean the data before storing it into the MySQL database - basically they would copy and paste directly from word into a text box and PHP would just store whatever that looked like. Looking at the old database the information is still preserved (e.g. a bullet point would like like one rather than an html tag etc.) but when I export the data in order to create a new database MySQL converts this information into a series of funny characters so that they import weirdly and means I cannot convert them back to their original format! For the most part it happens with '£' signs and bullet point (the many that word can output). Any ideas on how to correct these and clean this data in order to move forward would be massively appreciated. DK. Quote Link to comment https://forums.phpfreaks.com/topic/251551-mysql-data-export-problem-dirty-data/ Share on other sites More sharing options...
fenway Posted November 23, 2011 Share Posted November 23, 2011 That's likely a unicode game. Quote Link to comment https://forums.phpfreaks.com/topic/251551-mysql-data-export-problem-dirty-data/#findComment-1290803 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.