Halid, I think this is a php/phpmyadmin problem and not really a mysql problem.
PHP has an option called "magic quotes" that may be causing this. http://us2.php.net/manual/en/function.get-magic-quotes-gpc.php I have run into this before - I think what happens is that magic quotes will change a single quote ' to a double '' so its mysql safe. Then when it reads it back in from the database and renders the HTML, it also displays the doubles. If you look in the database iteself from the mysql command line client do the double quotes show? -- George Law > -----Original Message----- > From: Halid Faith [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 02, 2006 11:51 AM > To: mysql@lists.mysql.com > Subject: apostrophe char problem > > Hello > > I use mysql 4.1.16 and php4.3.10 and phpmyadmin2.7 and > apache-2.0.53 on > FreeBSD5.3 > > I add any text as data with phpadmin on web. it works well. > But I have a problem. > As example if I add a text to mysql table with phpadmin. > My text contains as below; > "Halid 's car is expensive" > > I will see above the sentence as "Halid ''s car is expensive" > on web (internet explorer) That is, I see that double ' > apostrophe character out > > What shall I do ? > > Thanks > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
