Apostrophe shows up as "ÔÇÖ" I pulled data out of a database and the apostrophe is showing up as "ÔÇÖ".  What character set is this from?
That specific character is from the character set Chinese_Hong_Kong_Stroke_90

There doesn't seem to be an easy way to "figure it out" from the output.  The most reliable way is to query the collation off the database.

select collation_name from sys.databases;