From: mrtima at aol dot com Operating system: Any PHP version: 4.3.1 PHP Bug Type: MySQL related Bug description: Query of MS-Word char causes ISO number to show up instead of actual character
Description: ------------ When certain MS-Word characters such as (’) are returned from a query in MySQL and displayed to a webpage, you see ’ instead. MS-Word parenthesis = ’ Standard ASCII paranthesis = ' Reproduce code: --------------- //database connection params include("db_conn.php"); //the database should have a MS-Word parenthesis in it (’) $result = mysql_query("SELECT textvalue FROM anytable"); $fetch_result = mysql_fetch_object($result); //display result to a webpage echo $fetch_result->textvalue; Expected result: ---------------- ’ Actual result: -------------- ’ -- Edit bug report at http://bugs.php.net/?id=25872&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=25872&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=25872&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=25872&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=25872&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=25872&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=25872&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=25872&r=support Expected behavior: http://bugs.php.net/fix.php?id=25872&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=25872&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=25872&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=25872&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=25872&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=25872&r=dst IIS Stability: http://bugs.php.net/fix.php?id=25872&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=25872&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=25872&r=float