Random  all over my site

[kitcorsa]

since upgrading from 1.3.9 to 1.5.1 my site has random Â

all over it it random places.

any one know why??

i have been going through my products and checking the sauce and removing these one by one, but some pages I seem to be able to remove.... for example, title in EZpages and products. There is no code just text in these titles why are this random things popping up??

[DrByte]

http://www.zen-cart.com/content.php?...8859-1-to-utf8

[kitcorsa]

great thanks!!

[romancoins]

great thanks!!

I have the same problem. I use 1.3.8a but i did not upgraded. This character "�" appeared spontaneously all over my site (ez pages, product pages, category descriptions).

I did not installed any modules or plugins lately so i jut can't explain it. The site worked perfectly for 5 years and know that happened.

I converted the database to utf-8 (same with English and configure.php) and the problem persist.

Here is how it looks on my site:
http://www.vapori.ro/vaporii_din_med..._fumatul_pasiv


If any of you have an idea about to solve this mystery i appreciate it!

Janos

[swguy]

If you do a view source, you'll find at the top of your page it has

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

This means you have more things to change. Did you set DB_CHARSET in your includes/configure.php file? And CHARSET in includes/languages/<YOUR_TEMPLATE>/YOUR_LANGUAGE.php ?

[romancoins]

If you do a view source, you'll find at the top of your page it has

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

This means you have more things to change. Did you set DB_CHARSET in your includes/configure.php file? And CHARSET in includes/languages/<YOUR_TEMPLATE>/YOUR_LANGUAGE.php ?

Thank you for your reply! Since my earlier post i did a full site and database restore from a backup. So the changes made were not saved. I reedited the configure.php, english php both in includes and in admin.

The same result

[romancoins]

define('DB_TYPE', 'mysql');
define('DB_PREFIX', '');
define('DB_CHARSET', 'utf8');
define('DB_SERVER', 'localhost');

This is the line added in configure.php. Maybe it should had been "utf-8" instead of "utf8"?

[swguy]

This suggests that your data is not UTF8. Did you see the second post in this thread from Dr. Byte?

[romancoins]

I attached a printscreen of my database my database was converted successfully form iso to Utf8. It was the first thing i did today when i sow the strange character appearing out of the blue. That's why i am so frustrated. I did everything by the book but nothing changes.

[RodG]

I converted the database to utf-8

How did you do this conversion? It isn't enough to simply change the field types. The data they contain also needs to be converted.

There's a module in the plugs section of this site that will do this for you.
http://www.zen-cart.com/downloads.php?do=file&id=1318

Don't forget the usual stuff. Backup your database first.

Cheers
RodG