How to convert TEXT on XML UTF8 RRS feed

  • Question

  • Hello everyone,

    I have a table field that is of type TEXT and contains an XML into it, but the kind of COLLATION is LATIN. How do I convert data to UTF8.

    I need to convert to a valid type for XML utf8 to export to a file. XML

    For example:
    select <convert data to utf8> from table

    Wednesday, September 18, 2013 12:27 AM


  • Hello,

    SQL Server supports only ASCII and Unicode, but not UTF-8; you have to convert the data during export, e.g. with SSIS = Integration Services package.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, September 18, 2013 3:50 AM