Re: Unicode

[Bruce Vining <bvining@xxxxxxxxxx>]

Character fields can be defined as being UTF-8 starting with V5R3.  Here is
some sample DDS for that:

                R RECORD
                  KEYFIELD       5
                  FIELD        100          CCSID(1208 *NORMALIZE)
                K KEYFIELD

When working with UTF8 fields you need to be aware of your job CCSID.  If
65535 your application will read/write using UTF8 encoding directly.  If
not 65535 then database will convert the UTF8 to/from your job CCSID on
read/write operations.

Bruce Vining



                                                                           
             <SRamanujan@sunga                                             
             rdfutures.com>                                                
             Sent by:                                                   To 
             midrange-l-bounce         <midrange-l@xxxxxxxxxxxx>           
             s@xxxxxxxxxxxx                                             cc 
                                                                           
                                                                   Subject 
             03/31/2005 10:01          Unicode                             
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
             Midrange Systems                                              
                 Technical                                                 
                Discussion                                                 
                                                                           
                                                                           




Hi All,
Is there a way to create a Unicode field in the table on iSeries?  I
know a Graphic/VarGraphic with CCSID 1200 is Unicode but can I create
one as Char/Varchar with CCSID to make it Unicode as well?
Thanks,
Sudha

Sudha Ramanujan
SunGard Futures Systems
sramanujan@xxxxxxxxxxxxxxxxxx
(312) 577 6179
(312) 577 6101 - Fax


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.