£ being displayed as ?

Posted on 2009-02-09
Last Modified: 2014-10-23
Recently moved an aging OSCommerce site to a different host and now the £ symbol within the product pages is being displayed as ? (in Firefox).

The PHP version has remained the same across the servers however the MySQL version has changed from v4 to v5 - and I'm guessing this is where the problem lies.

Has anyone else had this problem before ?

Question by:VINCENZO69
    LVL 31

    Accepted Solution

    It probably has something to do with the charset not matching up between your database and your html page.
    The easiest way to fix this is to use £
    LVL 1

    Expert Comment

    I had this problem with the euro symbol in the database being a ?

    try running the following query against the database:

    UPDATE currencies SET symbol_left = '£' WHERE code = 'GBP'

    this should work hopefully!

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Often people are aiming at development of perfect Magento websites. Though, it is easier said than done. You know what’s much easier? To ruin everything. It can be done in seconds. Many of us experimented with design, tried to change some values dir…
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
    This video discusses moving either the default database or any database to a new volume.

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now