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
LVL 8
HDatabase AdministratorAsked:
Who is Participating?
 
NetminderConnect With a Mentor Commented:
PAQed with points refunded (500)

Netminder
Site Admin
0
 
HDatabase AdministratorAuthor Commented:
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.

 
0
 
HDatabase AdministratorAuthor Commented:
How do I close the question now?
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
MarcnusCommented:
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
0
 
HDatabase AdministratorAuthor Commented:
Did you see my post above?  I already figured out the issue myself. It was just the conversion between Oracle and UNIX text file.


0
 
dann47Commented:
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

0
 
HDatabase AdministratorAuthor Commented:
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?
0
 
dann47Commented:
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
0
 
HDatabase AdministratorAuthor Commented:
No I understand all that...What I meant is I dont have the ability to close my own questions thats all ...
0
 
dann47Commented:
Yes you do, you request it.  As there is no acceptable answer, you request a close in the following section.

http://www.experts-exchange.com/Community_Support/
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.