Garbled letters

[acummins]

I have set up a test customer with non-english characters in his name. In phpmyadmin, the zc db collation is set to ‘utf8_general_ci’. However, I still see the customer’s name both in phpmyadmin and zc garbled. As recommended in crystalKoi’s tutorial (http://www.srw2d.com/content/utf-8-zen-cart) , I changed the charset to utf-8 in english.php files both in admin-includes-languages and includes-languages folders. I also changed the code in the query_factory file but the accented letters still look distorted. Am I doing something wrong or is there any other way of rectifying this problem?

Cheers

[MattyMatt]

When you view the source of your index page what do you see as the character set ?

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

is the default which could then mis-render items in UTF-8 also updating your website, your browser probably posts in UTF-8, I know I've had problems with the £ sign before and that's pretty basic.

[acummins]

I solved the problem. Actually, what I should have done was uninstall zc, create the db with the correct collation and then reinstall it. Well, before uninstalling zc, I changed the collation of the db but that didn't work well in every page so creating everything from scratch seemed to be only option. Do you know the difference between "utf8_general_ci" and utf8_unicode_ci"? Are they both the same or differ in some aspects to a certain extent?

[MattyMatt]

I don't (didn't) but I found a lonk on the mysql fourms that explains it very well

http://forums.mysql.com/read.php?103...748#msg-188748

[acummins]

Thanks for the hand