Character encoding issues: Pound-sign "£"

Hello,

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 "£" becomes a "ú" (u with
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?

Any ideas gang?

Alex

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Character encoding issues: Pound-sign

At 07:01 AM 12/13/2005, Alex Gemmell wrote:
>Hello,
>
>I'm experiencing some odd character encoding=20
>issues. My PHP webpage is displaying test from=20
>a MySQL database. What happens is that I export=20
>data from an SQL Server database to a MySQL=20
>(4.0) database. Somewhere along the line the=20
>British currency pound-sign "=A3" becomes a "=FA" (u=20
>with somesort of accent on it!). I cannot=20
>figure out why this is happening and what to do about it.
>
>I could use a PHP routine to find-and-replace=20
>the chars but surely there is a way to tackle the root problem?
>
>Any ideas gang?
>
>Alex

If you end up having to do conversion, perhaps=20
you should convert the pound signs to HTML=20
character representations ("=A3" translates to "£").

That's about all I can come up with... :)
Boddie


-----------------------------------------------
David Boddie, Webmaster, Graduate School
University of Arkansas | #6 Dickson Street Annex
Fayetteville, Arkansas 72701
Phone: 479-575-6184 | email: dboddie@uark.edu
http://www.uark.edu/grad
-----------------------------------------------=20

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Character encoding issues: Pound-sign

-----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

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: Character encoding issues: Pound-sign "£" becomes a "ú" - why?

Check that you are using the same ASCII character sets all around, in the
db, in the html output

Bastien

>From: Alex Gemmell
>To: php-db@lists.php.net
>Subject: [PHP-DB] Character encoding issues: Pound-sign "£" becomes a "ú" -
>why?
>Date: Tue, 13 Dec 2005 13:01:36 +0000
>
>Hello,
>
>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 "£" becomes a "ú" (u with 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?
>
>Any ideas gang?
>
>Alex
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Character encoding issues: Pound-

Alex Gemmell wrote:
> Hello,
>
> 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 "£" becomes a "ú" (u with
> 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?
>
> Any ideas gang?
>
> Alex

Try using the £ charachter.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php