spiderwell Posted February 21, 2012 Share Posted February 21, 2012 Hi all I am a bit stuck on this one, as I haven't come across it before and cannot seem to make it work. I am having to move a database from A to B, which is normally no problem, but in this instance I am having issues with French characters : é î À etc Whenever I export these characters break or stop working. I think its related to the fact the export is in plain text and not rich text? I might well be barking up the wrong tree with that one too!! Does anyone have any ideas on how to do this without losing characters? Thanks Quote Link to comment https://forums.phpfreaks.com/topic/257451-export-with-french-characters-not-working/ Share on other sites More sharing options...
fenway Posted February 22, 2012 Share Posted February 22, 2012 Those aren't french characters -- those are html entities. Quote Link to comment https://forums.phpfreaks.com/topic/257451-export-with-french-characters-not-working/#findComment-1319968 Share on other sites More sharing options...
spiderwell Posted February 22, 2012 Author Share Posted February 22, 2012 yes sorry that is my mistake, in the database there are some french characters still, is there a way to find and replace an entire table/database? Quote Link to comment https://forums.phpfreaks.com/topic/257451-export-with-french-characters-not-working/#findComment-1319993 Share on other sites More sharing options...
fenway Posted February 22, 2012 Share Posted February 22, 2012 You'd have to show us these characters, tell us about your database collations and character sets, and tell us what you mean by "break or not workign". Quote Link to comment https://forums.phpfreaks.com/topic/257451-export-with-french-characters-not-working/#findComment-1319999 Share on other sites More sharing options...
spiderwell Posted February 22, 2012 Author Share Posted February 22, 2012 again i dont have it with me, ill have to come back when i get home. Quote Link to comment https://forums.phpfreaks.com/topic/257451-export-with-french-characters-not-working/#findComment-1320009 Share on other sites More sharing options...
spiderwell Posted February 23, 2012 Author Share Posted February 23, 2012 managed to do this one my self Quote Link to comment https://forums.phpfreaks.com/topic/257451-export-with-french-characters-not-working/#findComment-1320343 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.