SOAP receiver Gibberish

[Former Member]

Hello.

I have s SOAP 2 SOAP scenario in SAP PI 7.0

I need to receive and send an UTF-8 encoded message to the web service.

The problem is - that although I didn't configured anything - when I look at the payload part in the message content tab of the soap receiver adapter - I see correct hebrew words. however when I right click -> view source I get the following Gibberish instead of the hebrew word: עמנ×u2022א×u0153 ר×u2014מ×u2122×

It seems that the adapter is trying to convert the UTF-8 encoding to something else.

Any one have any idea why?

Any help will be appreciated.

Thanks,

Imanuel Rahamim.

[stefan_grube · Accepted solution]

when I right click -> view source I get the following Gibberish instead of the hebrew word: עמנ×u2022א×u0153 ר×u2014מ×u2122×

right click opens Notepad. Notepad works with system encoding, that is cp1252 on a standard PC (western Europe latin)

Nothing is wrong here.

[Former Member · Accepted solution]

First of all thanks.

The problem is... that when the web service is trying to process the data, it ends up with question marks.

I thought that this was the cause...

In that case - the problem's origin is the web service itself? and not the encoding of the message?

[stefan_grube · Accepted solution]

Could you describe the process more detailled.

What is does the web service expect, what is the response?

Where do you see question marks?

Can your web service interpret UTF-8, or do you need a conversion of encoding?

[Former Member · Accepted solution]

As this is a third party web service, I can only tell what the provider told me.

The web service excpects UTF-8.

The web service gets the input, and update an SQL SERVER 2008 with it.

The type of the column is nvarchar.

after calling the web service, I make a select command in the sql query analyzer - and see question marks instead of hebrew.

The SQL server collation is Hebrew_CI_AI

As far as I can tell, I'm sending UTF-8 data, so where can the data go wrong?

[stefan_grube · Accepted solution]

Is your SQL studio capable to show hebrew corracters correctly?

Like Notepad, the display could be system encoding cp1252 only.

But without knowing the webservice, it is hard to guess what is going wrong.

[Former Member · Accepted solution]

Yes there is other data in there, and it is in correct hebrew (added by a local client, not the web service)

Thanks for the help.

[stefan_grube · Accepted solution]

You did not add any module or parameter to SOAP adapter?

By default the SOAP adapter sends UTF-8.

So the error might be inside the web service, or the web service requests other encoding.

[Former Member · Accepted solution]

Thank you all.

The problem was in the DB configuration after all (:

It is now fixed.