Single/double quotes in MySQL database
Posted: Mon May 07, 2007 2:51 pm
Using MySQL Ver 4.0.27-standard and PHP 4.4.4 (not able to change, shared server). Magic_quotes_gpc is turned on.
Problem arises when text/varchar field contains single/double quotes. Sometimes that is not a problem, other times the quotes are replaced by multiple unprintable characters which display in browser as single/double quotes but cause a spellchecker to crash. In phpmyadmin they show as hyroglyphics.
The application has been in place for a bit over a year without any problems and this has only recently begun to happen. It is rare and inconsistent. Sometimes within a single row some fields will contain the quotes okay while other fields in the same row will be trashed.
Can anyone point me in the direction of what is happing and how to solve it?
Problem arises when text/varchar field contains single/double quotes. Sometimes that is not a problem, other times the quotes are replaced by multiple unprintable characters which display in browser as single/double quotes but cause a spellchecker to crash. In phpmyadmin they show as hyroglyphics.
The application has been in place for a bit over a year without any problems and this has only recently begun to happen. It is rare and inconsistent. Sometimes within a single row some fields will contain the quotes okay while other fields in the same row will be trashed.
Can anyone point me in the direction of what is happing and how to solve it?