Originally Posted by
HeyIts007
...... 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
PHP Code:
// 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
PHP Code:
// 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
Bookmarks