application/atom+xml
«
»

mySQL data – £ showing as ?

GET HOSTING FOR 1 Cent! USE CODE: JURY

I have just transferred the hosting of a website (and the accompanying MySQL db)

All has gone fine apart from all pound signs ‘£’ are showing as a question marks ‘?’. They are in a ‘text’ field of the db.

Everything worked fine on the old server.

This is the head from the db on the old server:
================================

– MySQL dump 8.23
–
– Host: localhost Database: db
———————————————————
– Server version3.23.58

================================

and here it is from the new one:
================================

– phpMyAdmin SQL Dump
– version 2.11.4
– http://www.phpmyadmin.net
–
– Host: localhost
– Generation Time: Mar 18, 2008 at 11:34 PM
– Server version: 4.1.22
– PHP Version: 5.2.3

SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;

–
– Database: `db`
–

================================

I can only presume it’s to do with the different versions.

Any suggestions welcome.

Related Blogs

Share and Enjoy:
  • Digg
  • del.icio.us
  • Facebook
  • NewsVine
  • Reddit
  • StumbleUpon
  • Google Bookmarks
  • Yahoo! Buzz
  • Twitter
  • Technorati
  • Live
  • LinkedIn
  • MySpace

2 Responses to “mySQL data – £ showing as ?”

  • steven_ashdown:
    May 16, 2010 at 3:06 pm

    just something went wrong when you logged on

  • j k:
    May 16, 2010 at 3:25 pm

    Are you seeing the ?’s from a browser when viewing the webpage or when you’re in phpmyadmin?

    If you’re viewing from a webpage, change or add:

    meta http-equiv=”Content-Type” content=”text/html; charset=US-UTF-8

Contact Us | Terms of Use | Privacy Statement
Copyright © 2009 Webhosting and Web Design For Small Business. All Rights Reserved.

Designed by Kazzas-Sites