|
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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.