Countries displaying odd characters in drop down

[fjcv]

Hello everyone!

I was removing all the countries I did not need from the countries table and by error I deleted España, which is meant to be my principal country. When I manually added it again I started to get a question mark symbol for the Ñ character in the registration form.

So I followed this steps to solve it:

1. I inserted España in the database, which lead me to an error in the purchase email, it displayed the ñ when inserting the country but solved the registration form issue.

2. I deleted España from the countries table and added it again after changing the encoding of countries_name database field, and inserted it again.

3. I tried changing the encoding of the field to utf8_spanish_ci

None of that helped me, the thing is that I have a backup of the database prior to deleting the countries I don´t need but since my partner added a lot of products afterward I´m afraid that if I imported back I might messed up everything.

This are the values I´m using for Spain in the database, which were taken from my backup:

country_id 195
countries_name España
countries_iso_code_2 ES
countries_iso_code_3 ESP
adress_format_id 3

The site is www.touchtoys.es and I´m running ZenCart 1.3.9d with a template from zencart-template


Thanks in advance for your help!

[fjcv]

Hi,

I kept doing test but the situation is the same...

4. Changed the whoel database to UTF-8

5. Imported the backed up version of the countries table

6. I´ve created the file my_db_charset.php in /includes/extra_configures and also in admin/includes/extra_configures

This issue is driving me crazy...

[fjcv]

Sorry for double posting I got very nervous with this issue, I found the post about this issues here http://www.zen-cart.com/forum/showthread.php?t=93439.

If any mod sees this thread please remove it and pardon my anxiety...