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 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. 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? 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". 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. 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 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
Archived
This topic is now archived and is closed to further replies.