Post reply

XML encoding formats

  • April 19, 2004 at 9:22 am

    #161366

    In SQL Server, if you do not specify the XML encoding for a document, it defaults to UTF-8. With our my companies standard, this should be iso8859-1. Is there a way to change the default of the setting in SQL Server or will we have to pass the encoding for the XML in the structure (<?xml version="1.0" encoding="iso8859-1" ?&gt?


    "Keep Your Stick On the Ice" ..Red Green

  • April 20, 2004 at 8:02 pm

    #503561

    Here is one method of forcing encoding I have found in Microsoft's documentation.  If you can be more specific on how you wish to retrieve the data there may be a way of forcing the encoding for that too.

    http://server/virtualroot?sql=SELECT * FROM Customers WHERE CustomerID='ALFKI'&outputencoding=iso8859-1

    I must confess that I have not tested this, I have just copied it from Microsoft's documentation.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply