| Grant Croker 2005-12-13, 6:57 pm |
|
-----Original Message-----
> From: "Alex Gemmell" [agemmell@gmail.com]
> Date: 13/12/2005 14:07
> Hello,
Hi
> I'm experiencing some odd character encoding issues. My PHP webpage is =
> displaying test from a MySQL database. What happens is that I export =
> data from an SQL Server database to a MySQL (4.0) database. Somewhere =
> along the line the British currency pound-sign "=A3" becomes a "=FA" (u wi=
th =
> somesort of accent on it!). I cannot figure out why this is happening =
> and what to do about it.
> I could use a PHP routine to find-and-replace the chars but surely there =
> is a way to tackle the root problem?
Not really, SQL Server uses a Windows Code page to store its characters and =
I
guess MySQL server uses a DOS code page. ASCII chars they will be compatible=
but
for extended characters there will be mis-matches. The "=A3" is one such
mis-match, the "=80" will be another. I cannot remember what a DOS "=A3" loo=
ks like
in Windows. You will have to search and replace all "=FA" for "=A3" in your =
data
load scripts. =
> Any ideas gang?
-- =
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
|