I know, I know, you've had this a million times. But I have Googled on this and not come up with anything that really matches my problem, so I need some advice about refining my search. Here's the situation:
I have a site using shared hosting which is running Apache 1.3.27, PHP 4.1.2. As this is a site about France, accented characters are used a lot, but have never been a problem. Some such characters are entered via HTML forms on the site, others are in MySQL databases where they have been entered on my local system via MySQLcc. The characters are all 'proper' characters - ie, they are not stored as HTML entities. And that's all working fine. But... I'm revamping the site, and on my local system (Apache 2, PHP 4.3.4), where I'm doing the development, the exact same databases, using the exact same browser (Firefox, FWIW) have problems with accented chars, which are shown as a jumble of 2-3 chars. Any ideas why there might be this discrepancy? Could it have anything to do with the way PHP is installed on the two systems? And what is the general recommendation about storing accented characters in text fields on MySQL DBs? Convert to htmlentities during the saving? Problem with that is that I might need the same databases for generating email mail-outs where I'm not using HTML... This is a problem I thought I'd solved ages ago, so my head's in a bit of spin. Any advice is most welcome. -- @+ Steve -- PHP Internationalization Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
