Zen Cart Logo
Forums / General Questions / Text not appearing correctly - I'm getting Paté for Paté

Text not appearing correctly - I'm getting Paté for Paté

Locked

Views: 901

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
4 Nov 2010, 9:44 AM
#1
vickula avatar

vickula

New Zenner

Join Date:
Sep 2008
Posts:
16
Plugin Contributions:
0

Text not appearing correctly - I'm getting Paté for Paté

Hi
I've just upgraded from 1.3.8a to 1.3.9h everything seems to be working as before apart from the text.

I'm getting Paté for **Paté **and £ when it's supposed to be £.

See here for the problem on my 1.3.9h version
http://www.dalesbutchers.co.uk/shop

I still have the original working 1.3.8a version here
http://www.dalesbutchers.co.uk/store

Any ideas gratefully received.

Thanks

4 Nov 2010, 11:29 AM
#2
torvista avatar

torvista

Totally Zenned

Join Date:
Aug 2007
Location:
Gijón, Asturias, Spain
Posts:
2,874
Plugin Contributions:
7

Re: Text not appearing correctly - I'm getting Paté for Paté

If you manually change the browser character encoding to UTF-8 the £ shows correctly implying the data in the database in encoded in UTF-8 and/or (not sure I am right here) the Zen cart-Mysql link is defined as using utf-8.

4 Nov 2010, 12:30 PM
#3
jayenne avatar

jayenne

New Zenner

Join Date:
May 2005
Location:
London, England
Posts:
17
Plugin Contributions:
0

Re: Text not appearing correctly - I'm getting Paté for Paté

I think you have changed the correlation of the database table.
check your backup's correlation for that table and the new table and see the diff.

this is simple enough to fix by changing the correlation but i'd recommend going with the current one and changing all instances of bad characters instead - this will take far longer but be better ongoing.

4 Nov 2010, 7:28 PM
#4
vickula avatar

vickula

New Zenner

Join Date:
Sep 2008
Posts:
16
Plugin Contributions:
0

Re: Text not appearing correctly - I'm getting Paté for Paté

That's just it - I can't change the instances because in the backend they appear correctly.

I've checked the correlation in both databases and they are exactly the same.

9 Nov 2010, 1:55 PM
#5
vickula avatar

vickula

New Zenner

Join Date:
Sep 2008
Posts:
16
Plugin Contributions:
0

Re: Text not appearing correctly - I'm getting Paté for Paté

I eventually found the problem.
It was to do with the my template files - having copied them after updating they were still in iso-8859-1 so I changed this to UTF-8 in the html_header.php file and it sorted the characters out. :clap: