how to change encoding in Schema for Special Character?

Home Page Forums BizTalk 2004 – BizTalk 2010 how to change encoding in Schema for Special Character?

Viewing 2 reply threads
  • Author
    Posts
    • #15279

      Hello,

      I have a xml source file and will pass through Biztalk and transformed to flat file.

      In my source xml file, some special character will be included, (e.g. %u00fa%u00f3%u00ed%u00e1) and the file failed schema validation, here’s the error:

      An error occurred when parsing the incoming document: \”Invalid character in the given encoding.\”

      The source file doesn’t have XML declaration included. And the schema i created in BTS 2006 has the default:
      <?xml version=\”1.0\” encoding=\”utf-16\” ?>

      To solve this problem i want to change the schema encoding to
      <?xml version=\”1.0\” encoding=\”iso-8859-1\” ?>

      But i didn’t find any attribute in XML Schema for source file to change the setting that like what we got in Flat File schema, change \”Code Page\” to set to other encoding, though i didn’t find iso-8859-1 there.

      If i changed the encoding for source file, do i need to change it for transformed schema (in this case, flat file schema) as well?

      Can anybody shed some light on this?

      Many Thanks.

      Merry

    • #15280

      Solved this problem by using a custom pipeline:

      [url]http://www.winterdom.com/weblog/2006/01/31/FixMessageEncodingCustomPipelineComponentSample.aspx[/url]

      in the pipeline, choose to use encoding \”Western European\”, or called Latin-1 (iso-8859-1).

      It covers most West European languages, such as French (fr), Spanish (es), Catalan (ca), Basque (eu), Portuguese (pt), Italian (it), Albanian (sq), Rhaeto-Romanic (rm), Dutch (nl), German (de), Danish (da), Swedish (sv), Norwegian (no), Finnish (fi), Faroese (fo), Icelandic (is), Irish (ga), Scottish (gd), and English (en).

    • #17436

      [quote user="Anonymous"]Hello,

      I have a xml source file and will pass through Biztalk and transformed to flat file.

      In my source xml file, some special character will be included, (e.g. úóíá) and the file failed schema validation, here's the error:

      An error occurred when parsing the incoming document: \"Invalid character in the given encoding.\"

      The source file doesn't have XML declaration included. And the schema i created in BTS 2006 has the default:
      <?xml version=\"1.0\" encoding=\"utf-16\" ?>

      To solve this problem i want to change the schema encoding to
      <?xml version=\"1.0\" encoding=\"iso-8859-1\" ?>

      But i didn't find any attribute in XML Schema for source file to change the setting that like what we got in Flat File schema, change \"Code Page\" to set to other encoding, though i didn't find iso-8859-1 there.

      If i changed the encoding for source file, do i need to change it for transformed schema (in this case, flat file schema) as well?

      Can anybody shed some light on this?

      Many Thanks.

      Merry[/quote]

      • #25928

        I have the same problem

        • #25932

          hi, can somebody help? i have problems with czech diakritic

          thanks

          • #26333

            While Creating Message in Biztalk set TargetCharset to "ISO-8859-1"

            Message(XMLNorm.TargetCharset) = "ISO-8859-1"

Viewing 2 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.