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 Quote Link to comment 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. Quote Link to comment 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 Quote Link to comment 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. Quote Link to comment 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.