I need to store UTF-8 format data in SQLServer.
How is that done?

SQL supports UC2 format in nvarchar.

So, other than changing the field type to nvarchar..is it possible to convert the data to UTF 8 format while querying.

Please help