Archive for the ‘opensource’ tag
Sql Server 2008 Hosting
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 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.
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
Profithost – Configure Database Mail in SQL Server 2008