Limão instead of Limão

[drago]

For some reason my website is not recognizing special characters such as...

ç, ñ, ã. á

The outcome is... Limão instead of Limão

Any ideas to fix the issue? Thanks in advance!

[lat9]

You didn't give us much information to go on: What version of Zen Cart? Fresh install or upgrade? A link to your site?

It's a character-set issue, for sure. Is this a value from your database, from a customer entry or in a language file on your site?

[drago]

I am currently using zen cart 1.5. Language set is english.
My website is www.gifts-mart.com

Thanks

[drago]

Only titles are doing such. Everything else is working just fine.

[lat9]

Since your website indicates that it's using iso-8859-1 encoding for the website display, your database should be using latin1 encoding (i.e. DB_CHARSET in your two configure.php files should be set to 'latin1').

If the v1.5.0 or v1.5.1 was a fresh install instead of an upgrade, all of your database tables were created with utf8_general_ci encoding ... so you've got a mix of character sets and that's what's causing the characters to display improperly.

Please verify and supply:

1. The DB_CHARSET values in /includes/configure.php and /YOUR_ADMIN/includes/configure.php
2. The CHARSET values and the setlocale statements in /includes/languages/andover_modern/english.php, /includes/languages/english.php and /YOUR_ADMIN/includes/languages/english.php.
3. The actual collation of your database, as seen using a tool such as phpMyAdmin