I pulled data out of a database and the apostrophe is showing up as "ÔÇÖ". What character set is this from?
closed as unclear what you're asking by ypercubeᵀᴹ, Michael Green, John aka hot2use, mustaccio, Erik Apr 12 '18 at 16:26
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
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;