Topic
  • 1 reply
  • Latest Post - ‏2011-10-19T12:12:47Z by barbara_morris
JF5Y_Madur_Reddy
JF5Y_Madur_Reddy
1 Post

Pinned topic How to create a PF which can store text from English,Arabic,Polish, Chinies

‏2011-10-19T06:25:43Z |
Hi,
I am working on a new project which will have users across the globe. So user may interact with any language.
I need to create the database which can store the all languages text. I have tried with Graphic type with CCSID 1200 but in RPGLE I am not able to do string operations and any other temp fields I create with same type the compilation issue is coming up. Then I have tried with CCSID 1208 with Char type field. This is working but for any quiry data is coming as junk. Please let me know if you are aware of multi-lingual application support.
Thanks and Regards,
Sreedhar Reddy
Updated on 2011-10-19T12:12:47Z at 2011-10-19T12:12:47Z by barbara_morris
  • barbara_morris
    barbara_morris
    389 Posts

    Re: How to create a PF which can store text from English,Arabic,Polish, Chinies

    ‏2011-10-19T12:12:47Z  
    Your G field with CCSID 1200 is a "UTF-16" field. In RPG, you define a UTF-16 field with type C, not type G. (RPG uses the name "UCS-2" for this type.)

    Add this keyword to your H spec to set the default CCSID for UCS-2 definitions:
    
    H CCSID(*UCS2 : 1200)
    


    Then define your temp UCS2 fields like this:
    
    D tempname       s           25c    varying
    


    Using type A with CCSID 1208 will not work the way you want. The A fields are converted to/from the job CCSID when you read/write a record, so you are limited to the 256 characters in the job CCSID, rather than the full character set of UTF-8 (CCSID 1208).