Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Capital A with tilde above precedes all £ (pound) signs


poplarman

Recommended Posts

Posted

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.

Posted

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.

Posted

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...