rubing Posted February 13, 2008 Share Posted February 13, 2008 I am processing a text file with php and then inserting it into my database. This text file has some smart quotes: e.g. CheemoÂ’s Creation BaileyÂ’s: Eric Mcginty Barking Kudu: Lettin Go Live BillyÂ’s: which i execute a find and replace on: $str = preg_replace('/[\x91\x92]/u', "'", $str); $str = preg_replace('/[\x93\x94]/u', '"', $str); If I echo these entries before insertion they look completely normal! However, they refuse to be inserted. Any advise from anybody. thanks...really appreciate it! Link to comment https://forums.phpfreaks.com/topic/90824-mysql-not-accepting-replaced-smart-quote-characters/ Share on other sites More sharing options...
rubing Posted February 13, 2008 Author Share Posted February 13, 2008 ooops forgot that quotes have to be escaped before passed! Link to comment https://forums.phpfreaks.com/topic/90824-mysql-not-accepting-replaced-smart-quote-characters/#findComment-466058 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.