RE: Function of CCSID

[Rick Renkema <rick@xxxxxxxxxxxxxxxxxx>]

For more information on CCSID values and its main purpose, see the 'AS/400 
International Application Development' manual (SC41-5603-00).

The following is an extract of text in chapter 1.2.1.4.

"The Character Data Representation Architecture (CDRA) system of tags uses 
coded
character set identifiers (CCSIDs) to maintain data integrity when 
character data is
passed from system to system or from user to user. CCSIDs assign a value 
that
uniquely identifies the coded graphic character representation used for 
character
data."

"A database file created by a U.S. user contains a dollar sign and is read 
by a user in the United Kingdom and in Denmark. If the application does not 
assign CCSID tags that are associated with the data to the file, users see 
different characters."

U.S.            Code page: 037     CCSID: 65535    Code point: X'5B'    
Character: $
U.K.            Code page: 285     CCSID: 65535    Code point: X'5B' 
   Character: ?
Denmark         Code page: 277     CCSID: 65535    Code point: X'5B' 
   Character: A

If the application assigns a CCSID associated with the data to a file, the 
application
can use AS/400 CCSID support to maintain the integrity of the data. When 
the file is
created with CCSID 037, the user in the United Kingdom (job CCSID 285) and 
the user
in Denmark (job CCSID 277) see the same character. Database management 
takes
care of the mapping.

U.S.            Code page: 037     CCSID: 00037    Code point: X'5B'    
Character: $
U.K.            Code page: 285     CCSID: 00285    Code point: X'4A' 
   Character: $
Denmark         Code page: 277     CCSID: 00277    Code point: X'67' 
   Character: $


Regards,

Rick Renkema
AS/400 Development Manager
Create!print International
Phone:  +61 3 9824 6888
Fax:    +61 3 9824 6866
Mobile: +61 (0) 412 CPRINT (277 468)
E-mail: rick@createprint.com.au

"All great discoveries are made by mistake."

-----Original Message-----
From:   Eric DeLong [SMTP:eric.delong@pmsi-services.com]
Sent:   Thursday, 31 December 1998 1:56
To:     MIDRANGE-L@midrange.com
Subject:        Re: Function of CCSID


     Vikas,

     CCSID is used to identify how an object is incoded. The AS400 by
     default uses EBCDIC as opposed to ASCII. Also, international
     variations of EBCDIC and ASCII codes such as German, French, etc.
     Mostly, I've seen it used when importing/exporting data to another
     platform. Using CCSID, translation from EBCDIC to ASCII is
     performed automagically.

     HTH
     eric.delong@pmsi-services.com


______________________________ Reply Separator 
_________________________________
Subject: Function of CCSID
Author:  <MIDRANGE-L@midrange.com > at INET_WACO
Date:    12/30/98 9:50 AM


Hi,

I have just started working on the AS/400 platform about a month back,so
please excuse me if my doubts are too trivial!

My Query is,

What is the function of the Code Character Set Identifier(CCSID),and
where exactly is it required?Is it useful in database applications?

Thanks,

      -----Vikas

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to 
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: 
david@midrange.com
+---



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to 
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: 
david@midrange.com
+---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---