Bug #669: HTML entities stored as such retrieve as meta-ASCII

From: whit@transpect.com Operating system: Linux PHP version: 3.0.1 PHP Bug Type: MySQL related Bug description: I have a database where some of the strings contain HTML entities (such as "é"). When I used MySQL directly, it retrieves those entries correctly, showing the coding for the characters. However, PHP on retrieval converts them to the meta-ASCII equivalents ("é"). I know I can use htmlentities() to convert back - except that this doesn't work when I want to use the item for a furher MySQL search in cases like the entity above, since PHP will convert it back to "é" instead of "é", and then the string won't match. IMHO, the initial translation PHP is doing on retrieval from MySQL is inappropriate, since it both hinders further use of the string with MySQL, and isn't good HTML either - despite having been perfectly good HTML while sitting in the database. -- PHP Development Mailing List http://www.php.net/ To unsubscribe send an empty message to php-dev-unsubscribe@lists.php.net For help: php-dev-help@lists.php.net