Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
RSS feed with ISO8859 encoding

Answered RSS feed with ISO8859 encoding

  • Monday, August 22, 2005 3:40 PM
     
     
    Sign In to Vote
    0

    We have an XML source that reads an RSS feed. The document uses ISO8859 encoding, which causes an error in SSIS: "System does not support ISO8859 encoding". Is there any way around this?

    Thanks,
    Dirk

     

All Replies

  • Wednesday, August 24, 2005 9:29 AM
     
     
    Sign In to Vote
    0
    Is there no one who can assist me with this topic?
    Is it maybe possible to get a list of supported encodings from somewhere?

    Best regard,
    Dirk
     
  • Wednesday, August 24, 2005 5:40 PM
     
     
    Sign In to Vote
    0
    Likely this is by design.
    I will get back to you after some more confirmation.

    Thanks
     
  • Thursday, August 25, 2005 2:08 AM
     
     Answered
    Sign In to Vote
    0

    Andy Conrad (XmlDataReader dev) confirmed
    "I don’t think System.Xml supports that encoding.  Only the encodings in system.text.encoding are supported.  See     http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemtextencodingclasstopic.asp 
    "
    Thanks

     
  • Thursday, August 25, 2005 6:48 AM
     
     
    Sign In to Vote
    0
    AFAIK, there is no such thing as ISO-8859 encoding.
    There are several very different encodings defined by ISO 8859
    standard, e.g. iso-8859-1 (Latin 1), iso-8859-5 (Cyrillic), etc.
    I believe any of these are supported.

    I could not check the task now, but tested that
    Encoding    .GetEncoding("ISO-8859-1");
    works fine, while
    Encoding.GetEncoding("ISO8859");
    throws an error "'ISO8859' is not a supported encoding name".

    So the "ISO8859" without suffix is not a legal encoding,
    the feed is not correct.
     
  • Friday, August 26, 2005 3:05 PM
     
     
    Sign In to Vote
    0
    You were all right. I had the code ISO8859-15 in my feed, but as described the code is not supported. I didn't knew the importance of the "-xx" at the end so I did not post my extension "-15".

    After some mails with the developer of the feed I was able to get the RSS feed now with "UTF-8" encoding - This works perfect!

    Thanks for the help!