Apostrophe shows up as "ÔÇÖ"
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;