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

At 07:01 AM 12/13/2005, 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

If you end up having to do conversion, perhaps you should convert the pound signs to HTML character representations ("£" 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 -----------------------------------------------