Is there any way to get SQL Server result in charset different from the native database encoding?
I mean something like "set names" which is used by MySQL.
A:
You can do this on a per column basis
SELECT COLUMN Collate CollationName
From Table
Raj More
2009-12-01 15:34:12
Thank you for response; I didn't found utf-8 Collation. I passed a lot of discussions about that there is no utf-8 support on < mssql 08. ???
Jirka Kopřiva
2009-12-01 16:45:58
A:
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
SergeyKazachenko
2009-12-11 16:57:19