this is my first post in this forum.
I am using SQL Server 2008 and generating XML file.
XML file encoding by default is in UCS2 LE BOM , i need encoding in UTF-8.
Right now manually opening the xml in notepad ++ and converting the encoding.
Does SQL Server 2008 support UTF-8 encoding or i have to upgrade to SQL Server 2012
thanks for your time.