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! Quote 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! Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.