a simple question from new user

  • 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

  • 62 views but no one have answer ?

  • 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]

  • 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