Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 609
  • Last Modified:

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
0
H
Asked:
H
1 Solution
 
HAuthor 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
 
HAuthor Commented:
How do I close the question now?
0
 
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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
HAuthor 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
 
HAuthor 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
 
HAuthor 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
 
NetminderCommented:
PAQed with points refunded (500)

Netminder
Site Admin
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now