RE: [PHP-DB] Character encoding issues: Pound-sign "�" becomes a "�" - why?

2005-12-13 Thread Bastien Koert 


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


Bastien


From: Alex Gemmell <[EMAIL PROTECTED]>
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 +

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: [PHP-DB] Character encoding issues: Pound-sign

2005-12-13 Thread Grant Croker 


-Original Message-
> From: "Alex Gemmell" [EMAIL PROTECTED]
> 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

--
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 "£").


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

[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