php-i18n Digest 17 Nov 2004 10:49:42 -0000 Issue 260
Topics (messages 791 through 791):
Accented characters
791 by: steve
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
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
--- End Message ---
