I'm using the SOAP technique to read Sales Force data into a disconnected ADO recordset via "classic" ASP.  I'm having a problem any time apostrophes appear in the Sales Force source data.  If I view a problem record containing an apostrophe in a record in the Sales Force explorer it appears as some strange rectangle.  If I copy and paste that character into my code in an attempt to execute a "replace" I get errors in my development environment about converting the page to unicode.

 

Any ideas?  I'm sure I'm not the first person to have this problem but I haven't been able to find a resolution.

 

Thanks in advance.

 

Rich