sql server output charset

Is there any way to get MSSQL Server result in charset different from the native database encoding?

I mean something like "set na开发者_运维问答mes" which is used by MySQL.

---

What is the column type of your data? Is it varchar or nvarchar?

To get results in Unicode, simply cast varchar columns as nvarchar: SELECT CAST(Column AS nvarchar(size)) FROM Table

---

You can do this on a per column basis

SELECT COLUMN Collate CollationName
From Table