>ASC() is 39 ? That is 0x27 in hex and is equal to the apostrophe http://www.fileformat.info/info/unicode/char/2032/index.htm also known as single quote

Yes, that is correct. ASC() will return 39 and ASCW() will return 8242 when the character is a Prime character. I also changed the field type in the designer to be NVarChar(50). Then, I could see that my data class was returning a NVarChar data type for the SQLType at the parameter level. Despite that, I still cannot find the record.