Interview Question in SQL Server 2008
Interview Question :: MySQL data - £ showing as
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 version 3.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.
Loading ...