Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
May 22, 2007 06:47 AM|LINK
>So can the stored procedure return a field as a different datatype to the one stored?
>How is this conversion handled?
Explicitly using using CONVERT (although CAST can also be used)
>Can you ensure that the varchar is encoded as utf-8 and not using a codepage?
You can also specify an explicit collating sequence using COLLATE
The existing table will need to be changed from VARCHAR to NVARCHAR