[PHP-DB] Character encoding issues: Pound-sign £ becomes a ú - why?

2005-12-13 Thread Alex Gemmell 

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: [PHP-DB] Character encoding issues: Pound-sign £ becomes a ú - why?

2005-12-13 Thread David Boddie 

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 pound;).


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: [EMAIL PROTECTED]
http://www.uark.edu/grad
--- 


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