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
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;