In SQL, when dealing with Unicode data, use the right data types like NVARCHAR or NCHAR. To insert Unicode data, add an N before strings like N'' to indicate it's Unicode.

Returns the string made of the UTF characters whose Unicode codepoint value is provided by the arguments to this function. The input must consist of valid Unicode codepoints. If any argument isn't a ...

Displaying Unicode With Visual Basic 6. ... SQL's CAST() function is similar to CONVERT(); it lacks the date formatting capabilities CONVERT() has, but otherwise works in a similar fashion.