I recently opened up an old website of my own to a different webserver. I uploaded the database, the website files, checked the connections and everything is runnning smoothly. The only thing that i can't fix is that the greek language is displayed as
"????"
. Checked in database and everything is correct, the letters are showing and the coding is utf8. So i ended up thinking it is x-carts problem. What can i try to do? x-cart Version is 4.4.1.
You have to check these points:
1) You database.sql file to import is UTF-8. Greek symbols are readable in a text editor
2) every MySQL variable is UTF-8. Greek symbols are readable in a mysql client
3) Charset is UTF-8 on the ' Main page :: Edit languages :: Greek ' page
4)
mysql_query("SET NAMES 'utf8'");
is added to the include/func/func.db.php file according to https://help.x-cart.com/index.php?title=X-Cart:FAQs#How_do_I_set_up_my_X-Cart_to_support_UTF-8.3F