EDI pipeline with character set Extended


Receiving German Characters in the EDI message received by Biztalk 2006 R2. We have set the character set to "Extended" in the receive pipeline but it still fails in the receive pipeline.

Solution:

Found that the char set ‘Extended’ does not include the complete iso8859-1. It implements subset of the 8859-1 . The following is the list of characters in integers that we support/consider under `Extended` 32-93, 95, 97-126, 161, 191-194, 196, 199-202, 204-206, 209-212, 214, 217-220, 224-226, 228, 231-239, 241-244, 246, 249-252. The list of characters that we support under `Extended` are clearly a subset of ISO8859-1. For all chars outside of this list, we should use UTF8. We found that the messages received by Biztalk was not proper UTF8 as it was missing BOM headers. Once we added the BOM headers it worked with character set UTF8.

Comments (5)
  1. Anonymous says:

    This works for X12 or EDIFACT?

    I have a inbound x12 edi message which contains some French character à , the character set property in the EDI receive pipeline is set to UTF8.

    when I test the message, the edi pipeline throw exception," invalid character in data element "

  2. Atin Agarwal says:

    This works for both X12 and EDIFACT.

    Can you confirm if the message is not missing BOM headers? You can try opening the message in a notepad and save it after selecting encoding as UTF-8 and try it again using a File Adapter.

  3. Anonymous says:

    Hi Atin,

    Hope you remember me from hawaii client.How to add the BOM headers to BizTalk.my outbound EDIFACT is having German characters and it is failing while sending out of  EDI pipeline.

    Thanks…

    Surya

  4. Anonymous says:

    Thanks Atin,

    That information is real helpful.

Comments are closed.

Skip to main content