I have built a content management system and I am using MySQL as the DB and running on a Linux OS. When ever I paste text from MS word into a form and store it into the database, it has problems with certain characters, like quotes and hyphens. It seems to get confused with those characters and it displays them as random characters. It seems to me that MySQL does not support all of the windows char sets. Has anyone else come across anything like this? Is there a fix for it?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Char set problems
- Thread starter kingcheez
- Start date
yes there is a method. u have to replace those special characters with someother char.
e.g:
$str=str_replace($str,"'","SINGLQT"
;
try also using addslashes(), but magic qoutes must be on.
$str=addslashes($str);
Known is handfull, Unknown is worldfull
e.g:
$str=str_replace($str,"'","SINGLQT"
;try also using addslashes(), but magic qoutes must be on.
$str=addslashes($str);
Known is handfull, Unknown is worldfull
- Thread starter
- #3
- Status