Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

characters like � have appeared after restored backup of the site


alexman

Recommended Posts

Posted

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.

Posted

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;

}

Posted

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).

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...