Boo! The Unicode Consortium specifies logical order.
-- Shmuel (Seymour J.) Metz http://mason.gmu.edu/~smetz3 ________________________________________ From: IBM Mainframe Discussion List <[email protected]> on behalf of Gadi Ben-Avi <[email protected]> Sent: Monday, January 8, 2018 12:57 AM To: [email protected] Subject: Re: Transferring hebrew data from Db2 Z/OS to PC עיברית קשה שפה Your data is fine. The problem is with the way Windows expects Hebrew to be stored. On z/OS, Hebrew is usually stored visually - the first letter in a word is on the right. On other platforms, including Windows, Hebrew is stored logically - the first letter is on the left, and programs reverse the data before it is displayed. This gets even more complicated when the data contains a mixture of Hebrew, English, digits. Special characters make it even more complicated. There are utilites to fix the data, but non are perfect. Gadi -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of Yaron Tal Sent: Monday, January 8, 2018 7:40 AM To: [email protected] Subject: Transferring hebrew data from Db2 Z/OS to PC Hi everyone, I am trying to move large amounts of data from Db2 Z/OS to other platforms. This is done by running UNLOAD utility to prepare a file and then FTP the file to my PC in order to LOAD it later onto another platform. File has a mix of fields - integers, decimals and characater data which includes hebrew, english and special characters like : " , ( . Problem is - hebrew data gets reversed (left to right ordering) in the process. I am using BlueZone FTP by Rocket Software which is quite fast (we're talking about large amounts). IBM Personal Communications emulation moes the data in right order (using BIDI options - implicit ordering) but is very slow and might take weeks for the entire set of data to be moved. Will appreciate your help on how to get the hebrew on the right direction using normal FTP process, Thanks! ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN לתשומת ליבך, בהתאם לנהלי חברת מלם מערכות בע"מ ו/או כל חברת בת ו/או חברה קשורה שלה (להלן : "החברה") וזכויות החתימה בהן, כל הצעה, התחייבות או מצג מטעם החברה, מחייבים מסמך נפרד וחתום על ידי מורשי החתימה של החברה, הנושא את לוגו החברה או שמה המודפס ובצירוף חותמת החברה. בהעדר מסמך כאמור (לרבות מסמך סרוק) המצורף להודעת דואר אלקטרוני זאת, אין לראות באמור בהודעה אלא משום טיוטה לדיון, ואין להסתמך עליה לביצוע פעולה עסקית או משפטית כלשהי. Please note that in accordance with Malam and/or its subsidiaries (hereinafter : "Malam") regulations and signatory rights, no offer, agreement, concession or representation is binding on the Malam, unless accompanied by a duly signed separate document (or a scanned version thereof), affixed with the Malam seal. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
