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 "£" 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? 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 "£" is one such mis-match, the "€" will be another. I cannot remember what a DOS "£" looks like in Windows. You will have to search and replace all "ú" for "£" 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