Can there be any method of getting SQL Server lead to charset not the same as the native database encoding?

I am talking about something similar to "set names" which is often used by MySQL.

This can be done on the per column basis

SELECT COLUMN Collate CollationName
From Table

What's the column kind of your computer data? Could it be varchar or nvarchar?

To obtain leads to Unicode, simply cast varchar posts as nvarchar: Choose CAST(Column AS nvarchar(size)) FROM Table