ID: 25872
Updated by: [email]iliaa@php.net[/email]
Reported By: mrtima at aol dot com
-Status: Open
+Status: Bogus
Bug Type: MySQL related
Operating System: Any
PHP Version: 4.3.1
New Comment:

Sorry, but your problem does not imply a bug in PHP itself. For a
list of more appropriate places to ask for help using PHP, please
visit [url]http://www.php.net/support.php[/url] as this bug system is not the
appropriate forum for asking support questions.

Thank you for your interest in PHP.

You are probably inserting the encoded values into MySQL.


Previous Comments:
------------------------------------------------------------------------

[2003-10-14 15:58:37] mrtima at aol dot com

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 this bug report at [url]http://bugs.php.net/?id=25872&edit=1[/url]