New Zenner
- Join Date:
- Nov 2010
- Posts:
- 6
- Plugin Contributions:
- 0
Countries displaying odd characters in drop down
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:
-
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.
-
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.
-
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 https://www.touchtoys.es and I´m running ZenCart 1.3.9d with a template from zencart-template
Thanks in advance for your help!