August 17, 2011 at 8:52 am
Good day,
We have a legacy database that has a number of fields specified with the NVARCHAR datatype.
The application and data model are being extensively revised in a new release, where I plan to use VARCHAR instead of NVARCHAR. We will never have a need for multibyte characters.
When we migrate the data to the VARCHAR columns, should we explicitly convert it to VARCHAR in the ETL process, or will SQL Server 2008 do the conversion natively?
As always, any advice is much appreciated.
Steve
August 17, 2011 at 10:52 am
I would explicitly CAST as VARCHAR.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 17, 2011 at 11:18 am
Much appreciated sir.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply