Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server datatype "best" for use in creating XML file

Status
Not open for further replies.

alexjones

Programmer
Jul 27, 2001
132
US
XML Newbie question. The XML file being created is UTF-8 encoded. Does it make any difference if the data is stored in SQL Server as varchar or nvarchar?
 
You are already advised by the MS SQL manuals to use nvarchar anyway, so why not use it for all your data, and never worry about the xml , or whatever file-format, export?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top