Post reply

a simple question from new user

  • January 30, 2018 at 11:18 pm

    #343175

    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

    #1978124

    62 views but no one have answer ?

  • February 1, 2018 at 3:12 am

    #1978153

    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

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • February 3, 2018 at 9:57 pm

    #1978455

    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