c_shelswell Posted May 31, 2007 Share Posted May 31, 2007 I've got a bit of a problem with a table on my database. It seems to have substituted "é" for "é" it's also done funny things with other foreign characters. I'm not entirely sure when or how this happened but now i'm having trouble comparing tables as it obviously sees things differently. I have one table that is showing them correctly and one that's not. I don't have a numerical key against those words (something i might add now i think ) Can anyone tell me how this might have happened and also if there's an easy way of sorting it. Am i best just to do a PHP preg_replace?? Many Thanks Link to comment https://forums.phpfreaks.com/topic/53754-problem-with-character-encoding-i-think/ Share on other sites More sharing options...
fenway Posted May 31, 2007 Share Posted May 31, 2007 Combination of database collation and php encoding charset. Link to comment https://forums.phpfreaks.com/topic/53754-problem-with-character-encoding-i-think/#findComment-265767 Share on other sites More sharing options...
c_shelswell Posted June 1, 2007 Author Share Posted June 1, 2007 so could that be a result of switching from a windows phpMyAdmin to a Linux phpMyAdmin ? Don't suppose there's any easy function in mysql to remedy this is there? Thanks Link to comment https://forums.phpfreaks.com/topic/53754-problem-with-character-encoding-i-think/#findComment-266118 Share on other sites More sharing options...
fenway Posted June 1, 2007 Share Posted June 1, 2007 Could be, I don't know what they were before/after. Link to comment https://forums.phpfreaks.com/topic/53754-problem-with-character-encoding-i-think/#findComment-266261 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.