pfa Posted August 19, 2007 Share Posted August 19, 2007 I'm trying to help a friend with a web site. His server upgraded his php and mysql. mysql info: Ver 14.7 Distrib 4.1.11, for pc-linux-gnu (i386) php 4.4.7 The restored database has latin1_swedish_ci. Unfortunately we are unsure what the previous one was (he thinks utf8/unicode but can't say) and of course it's been trashed by his provider. The text which is appearing incorrectly in the screen is (I believe) being parsed using utf8_decode(). Basically the characters are appearing as un-encoded utf8 (or something to that effect). I'm hoping that the restore hasn't trashed the unicode and that it's a *.ini setting. We tried changing the charset/collation of the db and I even recreated one of the tables from a select of one of the offending tables and set the collation to utf8_unicode_ci but made no difference. Any help would be much appreciated. Quote Link to comment Share on other sites More sharing options...
pfa Posted August 19, 2007 Author Share Posted August 19, 2007 Just a follow up, when I select hex(column) from one of the tables the ? I see on the screen do in fact seem to be ? in the table :'( 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.