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?
Single/double quotes in MySQL database
Moderator: General Moderators
Could you provide a sample of these multiple unprintable characters (hex encoded byte values)? Chances are these characters are utf sequences, but I can't be sure without seeing them.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.