alexman Posted November 13, 2013 Posted November 13, 2013 I've restored my backup's site, and in my french menu pages it appears caracthers replaced with simbol like this:� For example word "systeme" apppear like Syst�me.There a lot of these in all menu french. I've also checked in database and everything looks ok; all the words are without modifications. Why is happen this and how can I resolve it without replacing each character again. My site has OSC2.3.3 version.
alexman Posted November 13, 2013 Author Posted November 13, 2013 I solved using trial of user stragami from previous topic: I've replaced in includes/function/database.php if ($$link) mysql_select_db($database); return $$link; } with if ($$link) mysql_select_db($database); mysql_query("SET CHARACTER SET 'utf8'"); return $$link; }
stragami Posted November 13, 2013 Posted November 13, 2013 lucky you :thumbsup: for me it was not working.... :(
burt Posted November 13, 2013 Posted November 13, 2013 You need to update from 2.3.3 -> 2.3.3.1 -> 2.3.3.2 -> 2.3.3.3 -> 2.3.3.4
MrPhil Posted November 13, 2013 Posted November 13, 2013 It sounds like you failed to properly restore the site. When you create a new database, it will be Latin-1 by default. If you are going to restore a UTF-8 database, you need to manually set the encoding/collation to UTF-8 before restoring the backup (and don't forget to tell phpMyAdmin that it's a UTF-8 backup). Your "fix" is going to wastefully check the encodings on everything every time to call that function. It only needed to be done once (and can probably be removed from the code now).
Recommended Posts
Archived
This topic is now archived and is closed to further replies.