poplarman Posted December 11, 2013 Posted December 11, 2013 Following an update the £ sign appears with a preceding A with a tilde above it when prices are displayed. tools/database tables shows the collation as utf8_unicode_ci and a browse of my page source contains a META with content="text/html; charset=utf-8" Can anyone help please.
MrPhil Posted December 11, 2013 Posted December 11, 2013 Did this update involve backing up the database and reimporting it? If so, it sounds like you might have failed to tell phpMyAdmin that the backup file was UTF-8 and it assumed it was Latin-1 (and translated the two UTF-8 bytes as two Latin-1 accented characters). You should see in phpMyAdmin that the £ sign anywhere in the database is the double-character now, if that's what happened. Otherwise, if the server was updated, it might be that it's forcing Latin-1 display (due to misconfiguration). Go into your browser and View > Character Encoding to see if it's UTF-8 or Latin-1, and if Latin-1, change it to UTF-8 and see if the page displays correctly.
poplarman Posted December 11, 2013 Author Posted December 11, 2013 Thank you MrPhil. I don't know what caused the unusual character symbol against the pound sign but you gave me a clue that allowed me to fix it. Within the database there is a table 'currencies' and, within the field 'symbol_left' the £ sign had the addition. Changed it and wallah -all is fine. Thanks again.
poplarman Posted December 11, 2013 Author Posted December 11, 2013 Similar change was needed in table orders_total, field 'text'
Recommended Posts
Archived
This topic is now archived and is closed to further replies.