asked on

SAP and Transfering Double Byte Characters properly

Hello SAP experts,

I’ve got an issue with double byte characters coming from UNIX/Oracle/SAP system to AS/400 based system

Example:

Oracle has a name: begoña

Funny part is that length (begoña) = 6, but lengthb (begoña) = 7

It means that it took seven bytes in the output string, but it arrived to AS/400 as: begoÃ±a

It looks like it coded differently. AS/400 is using CSID = 500 to support these characters.

Question is how it should be sent from Unix/Oracle to be translated correctly?

Thank you

ASKER

Hi

Had to figure it out on my own but figured I post it...

It was a specific part of the process when I write a string from Oracle stored procedure to UNIX flat file using Oracle UTL_FILE utility. Its goes there in a wrong format and gets sent down exactly same way via MQseries to the as/400 appication..

So it has nothing to do with MQseries or the AS/400. It was just the conversion between Oracle and UNIX text file.

ASKER

How do I close the question now?

Marcnus

Hello,

in SAP it depends on way you would like to export files. From ABAP you can find all
information on http://help.sap.com/saphelp_47x200/helpdata/en/62/3f2cadb35311d5993800508b6b8b11/frameset.htm
from Oracle you can use uniceode datatypes.

Regards,
mw

ASKER

Did you see my post above? I already figured out the issue myself. It was just the conversion between Oracle and UNIX text file.

dann47

No comment has been added to this question in more than 21 days, so it is now classified as abandoned.
I will leave the following recommendation for this question in the Cleanup topic area:

PAQ - Refund

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

Dann47
EE Cleanup Volunteer

ASKER

Actaully I thought it would be a good idea to leave out here so it can be found with searches since I had to anser it myself...It would be nice if the person the fisrt added the question had the ability to close the question..The only options I had were to delete it or accept the only posted comment?

dann47

Points are refunded due to answering your own question. The question is saved for future searches. The question is only closed for an answered point of view. Please read the member help on what closing a question does. Hope this clears this up, if not, please say so.

Regards

Dann47

ASKER

No I understand all that...What I meant is I dont have the ability to close my own questions thats all ...

dann47

Yes you do, you request it. As there is no acceptable answer, you request a close in the following section.

https://www.experts-exchange.com/Community_Support/

ASKER CERTIFIED SOLUTION

Netminder

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial