How can I deal with special characters in query results from mssql using php
Posted on 2013-12-05
I have a query that returns product description, and I have run into a problem dealing with the returned values. This data is coming from MSSQL and I am using php to query the data.
Two specific things I have run into is data that includes a product name with a copyright signal next to it. And the other is quotations and apostrophes that are tilted in/out instead of just the keyboard standard. Does that make sense?
I am sure there are others . . ..
Is there anyway I can utilize these special characters? The data is going into mysql Magento database. If not, is there a way to get around the ? signs that are displayed instead?