French characters

["Don" <don@xxxxxxxxxxxxx>]

Hi,

I use PHP to read data form a mysql 5 table. allow the user to edit the data 
and then update the table.  I am having trouble with French characters.

Before the update:  Pas de description détaillée
After the update:    Pas de description détaillée

When I read from the table I wrap the data in the following:
    // Stripslashes
    if (!get_magic_quotes_gpc()) {
        $value = stripslashes($value);
    }
    // Convert all applicable characters to HTML entities
    $value = htmlentities($value,ENT_COMPAT);

When I update to the table, I wrap in the following:
    // Addslashes
    if (!(get_magic_quotes_gpc())) {
       $value = addslashes($value);
    }
    // Quote if not a number or a numeric string
    if (!is_numeric($value)) {
       $value = @mysql_real_escape_string($value);
    }

I've tried playing with character sets to no avail.  There mst be a 
solution,

Thanks
Don 



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