NVARCHAR(10) TO VARCHAR(15) in result set

[groadsvb]

I have a request to provide a select statement to a business partner that will execute the select statement several times a day. The definition of several of the fields from the partner is VARCHAR(??). We store all of our fields in NVARCHAR(??) because of localization. Do I need to convert the resulting column in the result set or does it matter as long as the data does not exceed the length in the result? Thanks.

 

[jmcilhinney]

You're asking this question in a VB.NET forum so that would suggest that it is related to a VB.NET application. All text data types in SQL Server end up as Strings in VB.NET regardless of whether they are single- or double-byte and fixed- or variable-width.