January 30, 2018 at 11:18 pm
Dear Expert,
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.
regards,
Imran
January 31, 2018 at 8:36 pm
62 views but no one have answer ?
February 1, 2018 at 3:12 am
SQL Server always stores XML internally as UCS-2 so it is impossible for SQL to generate a UTF-8 encoding header
https://technet.microsoft.com/en-us/library/ms187107(SQL.90).aspx
February 3, 2018 at 9:57 pm
thanks for your reply.
is there any way to achieve this in SQL Server or any other tool to covert encoding of xmls grammatically.,
some guys advised me to upgrade from SQL server 2008 to SQL Server 2012 or above , that will solve the purpose.
regards,
Imran
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply