Umlaute u00E4/u00F6/u00FC and accents in IDOCs coming from ERP

[former_member210324]

Hi,

I am facing a problem where the ERP sends me a LOIPRO or MATMAS containing some user entered texts (e.g. Materialdescriptions, operation names). The could from the ERP side be any text containing also unicode characters.

For example the user could enter an "ü". This is by definition not allowed directly in XML files for the encoding UTF-8.

I would expect that the system transforms these values to "ü" for the ü.

My main problem in the background is that the XML fed into a SQL Server xml field generates an error.

Is there any way to transform this except a lot of string replaces? (I am doing this at the moment)

Kind Regards,

Christoph

[Former Member]

Hi guy,

i had an encoding error  like this. In my case the XML become to SQL Server with the header belows:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

It's the default header in MII XML variables. In funy way the default XML processor in SQL Server only understands UTF-16 encoding. To treat this encoding error i just use this lines in XML variable at the moment to send it to SQL Query, trying to change the encoding ( rs.. 😞

stringreplace(Local.test, " encoding=" & doublequote & "UTF-8" & doublequote, "")

I expect a more professional solution to this, but now is the only one i knows.

Thanks,

[jamie_cawley]

UTF-8 supports umlauts, sounds like you problem may be on the db side, what type is the column defined as in the db and what is the collation set to?

Regards,

Jamie

[agentry_src]

What version of NW and MII are you working with?

From what you describe, I would first start with the user ID defined for the IDoc Listener and see what language the default to. There may also be some mechanism in ECC to define a default language for the IDocs (not real sure about this one, an ALE/Basis person would be the one to ask).

Good luck!