Random  all over my site

[romancoins]

I used for the conversion DrByte's tool - the same one you pointed to. Downloaded it form here: http://www.zen-cart.com/content.php?313

I was thinking if i should change that line in english.php:

setlocale(LC_TIME, 'en_US.ISO_8859-1');

to

setlocale(LC_TIME, 'en_US.utf-8');

But i don't thing that this has anything to do with my problem. I spoke with the hosting company meanwhile - and after 2 hours of looking around my site they said it is an encoding problem somewhere.... :) voila that's technical support for you :)

[RodG]

I used for the conversion DrByte's tool - the same one you pointed to. Downloaded it form here: http://www.zen-cart.com/content.php?313

I was thinking if i should change that line in english.php:

setlocale(LC_TIME, 'en_US.ISO_8859-1');

to

setlocale(LC_TIME, 'en_US.utf-8');
But i don't thing that this has anything to do with my problem.

On the contrary, it could have everything to do with the problem Try changing it anyway and see what happens.

I spoke with the hosting company meanwhile - and after 2 hours of looking around my site they said it is an encoding problem somewhere.... :) voila that's technical support for you :)

Well, yes, they are correct.

Bottom line is that you need to change any and all references of ISO_8859-1 to UTF-8 regardless of which file it is in.

Edit /admin/includes/languages/english.php (and all other language_name.php files in that folder) and set the define for CHARSET to 'utf-8'.
Do the same with the non-admin /includes/languages/english.php (and other language_name.php files in that folder)

I apologise if you've already done this too, but the fact that you are still seeing these implies that you must have missed at least one of them somewhere.

Cheers
RodG

[romancoins]

Dear RodG thank you for your help! I appreciate it very much!

I changed the setlocale line to utf-8. No change.

English is my only language installed on zencart so nothing else to modify.

I think that i am looking for a lot fo manual editing. :)

[HeyIts007]

I just upgraded from v1.39h to v1.53 and I had a similar problem with  characters, however I had the  problem in v1.39 also I think due to a database restore into a updated server MySQL v5.3 and PHP v5.4 environment. I ran this suggested convert_db2utf8.php script and it did not seem to get rid of all the  characters. Thus I still have  characters in my product descriptions, but not as many. Is there another scripted fix for this ?

Are there any other PHP files we need to modify for UTF-8 ? I checked configure.php for store and admin and also the english.php in my template.

[HeyIts007]

I've noticed that charset=iso-8859-1 is in quite a few files, not just configure.php and english.php I've only followed the instructions to edit those 3 files and the configure files were already in UTF8 format from the start.

Other files identified include:

/nddbc.html
/includes/classes/class.phpmailer.php
/includes/functions/functions_email.php
/includes/functions/functions_general.php
/includes/templates/template_default/templates/tpl_zc_install_suggested_default.php

/ADMIN
/alert_page.php
/includes/header.php

Does that have any impact?

[DrByte]

Other files identified include:

/nddbc.html
/includes/classes/class.phpmailer.php
/includes/functions/functions_email.php
/includes/functions/functions_general.php
/includes/templates/template_default/templates/tpl_zc_install_suggested_default.php

/ADMIN
/alert_page.php
/includes/header.php

Does that have any impact?

In original ZC 1.5.3 code, any mention of iso-8859-1 in those particular files is intentional, and has nothing to do with the data coming from your database.

[frank18]

...... Is there another scripted fix for this ?.....

Not to my knowledge.

I just encountered this problem yesterday with a site of a client - inherited that site with the task to do all the maintenance....

That site had previously been upgraded from 1.3.9h to 1.5.1 (by the owner) - I did the upgrade to 1.5.3 a week ago. The site was an absolute mess, 5 additional language packs installed, some on utf-8, some on iso-8859-1 and one language pack (Romanian) with a mixed bag of both, say no more. The site displayed funny characters all over the place.

After upgrading the Italian and Spanish packs to utf-8 versions, many of the funny characters disappeared. It left me with fixing the French and Romanian packs by changing their defines to utf-8 both in admin and catalog side. Result was less funny characters again but some of the product pages have to be edited manually - no other choice as I won't risk running the convert_db2utf8.php script because most product pages are already utf8 encoded, only some are left with iso-8859-1 encoding.

To fix this, one would need to copy the affected product descriptions to a plain text editor (I use gedit in Linux) to strip all formating and from there back into the site's CKEditor, save and done. It is a tedious undertaking but it is the only option left to get this site cleaned up. You may have to do the same....

A little piece of advice: if you download a new language pack, make sure that the files in the downloaded pack are all utf-8 and that the defines in the files includes/languages/your_language.php (admin and catalog) have the definitions

// look in your $PATH_LOCALE/locale directory for available locales.. 
setlocale(LC_TIME, 'es_ES.UTF8');//unix 
setlocale(LC_TIME, 'Spanish_Spain.1252');//windows 

(above example from the Spanish pack which is well maintained by torvista)

and

// charset for web pages and emails 
define('CHARSET', 'utf-8'); 

which are both found pretty much near the top of the files (catalog and admin side).

Sadly, many of the language packs in the Plugins section of this site have not been updated for ages..... so caution is required.

Cheers / Frank

[HeyIts007]

Hmm ok. I tried that iso-8859-1 to utf8 conversion tool, which seemed to help a bit, however as you indicated, the data seems to be another issue. I have been manually doing just what you suggested. i.e. copying the text into an editor and doing a search and replace of  with null characters. This works ok, however is very tedious.

I just did a search for  characters in ZenCart Admin mode and it returned 317 product entries. Not sure if I have that many products, so I'm wondering if it means 317 occurrences of  character. Anyway t's a real pain having to manually clean out the  and other strange characters. I think someone mentioned some kind of module addon that can do this, so I might take a look at it.

Thanks,
007

[HeyIts007]

Oh seems the module mentioned was really the iso-8859-1 to utf8 conversion tool, so seems like back to manual editing.

[Feznizzle]

Dumb question... but I have to ask!

On an old zc139h, I'm attempting to follow CONVERT TO UTF8 instructions found here:
https://www.zen-cart.com/content.php...8859-1-to-utf8

Step one says set the define for CHARSET to 'utf-8'.
Step two says set DB_CHARSET to 'utf8'.

The first reference contains a dash (utf-8), the second does not. Is that correct?