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. Link to comment https://forums.phpfreaks.com/topic/65654-solved-server-upgraded-chinese-characters-now-displaying-incorrectly/ 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 :'( Link to comment https://forums.phpfreaks.com/topic/65654-solved-server-upgraded-chinese-characters-now-displaying-incorrectly/#findComment-328158 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.