ÀÀ¿ëÇÁ·Î±×·¥ °³¹ß ¾È³»¼­

ºÎ·Ï E. EBCDIC 2Áø Á¶ÇÕ ½Ã¹Ä·¹ÀÌÆ®

DB2¸¦ »ç¿ëÇÏ¿©, »ç¿ëÀÚ Á¤ÀÇ Á¶ÇÕ ¼ø¼­¿¡ µû¶ó ¹®ÀÚ¿­À» Á¶ÇÕÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ·± ±â´ÉÀ» »ç¿ëÇÏ¿© EBCDIC 2Áø Á¶ÇÕÀ» ½Ã¹Ä·¹ÀÌÆ®ÇÒ ¼ö ÀÖ½À´Ï´Ù.

EBCDIC Á¶ÇÕÀ» ½Ã¹Ä·¹ÀÌÆ®ÇÏ´Â ÇÑ ¿¹·Î, ÄÚµå ÆäÀÌÁö 850À¸·Î ASCII µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇÏ·Á ÇÏÁö¸¸ ¸¶Ä¡ µ¥ÀÌÅͰ¡ ½ÇÁ¦·Î ÄÚµå ÆäÀÌÁö 500ÀÇ EBCDIC µ¥ÀÌÅͺ£À̽º ÀÖ´Â °Íó·³ ¹®ÀÚ¿­À» Á¶ÇÕÇÏ·Á ÇÑ´Ù°í °¡Á¤Çغ¾½Ã´Ù. ÄÚµå ÆäÀÌÁö 500ÀÇ Á¤ÀÇ¿¡ ´ëÇØ¼­´Â ±×¸² 26, ÄÚµå ÆäÀÌÁö 850¿¡ ´ëÇØ¼­´Â ±×¸² 27¿¡¼­ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.

2ÁøÀ¸·Î Á¶ÇÕÇÒ ¶§ EBCDIC ÄÚµå ÆäÀÌÁö 500 µ¥ÀÌÅͺ£À̽º¿¡ ÀÖ´Â ³× ¹®ÀÚÀÇ »ó´ë Á¶ÇÕÀ» °í·ÁÇØº¸½Ê½Ã¿À.

¹®ÀÚ
ÄÚµå ÆäÀÌÁö 500 ÄÚµå Æ÷ÀÎÆ®
'a'
X'81'
'b'
X'82'
'A'
X'C1'
'B'
X'C2'

ÄÚµå ÆäÀÌÁö 500 2Áø Á¶ÇÕ ¼ø¼­(¿øÇÏ´Â ¼ø¼­)´Â ´ÙÀ½°ú °°½À´Ï´Ù.

    'a' < 'b' < 'A' < 'B'

ASCII ÄÚµå ÆäÀÌÁö 850À¸·Î µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇÒ °æ¿ì 2Áø Á¶ÇÕÀº ´ÙÀ½°ú °°Àº °á°ú¸¦ ³º½À´Ï´Ù.

¹®ÀÚ
ÄÚµå ÆäÀÌÁö 850 ÄÚµå Æ÷ÀÎÆ®
'a'
X'61'
'b'
X'62'
'A'
X'41'
'B'
X'42'

ÄÚµå ÆäÀÌÁö 850 2Áø Á¶ÇÕ ¼ø¼­(¿øÇÏÁö ¾Ê´Â ¼ø¼­)´Â ´ÙÀ½°ú °°½À´Ï´Ù.

    'A' < 'B' < 'a' < 'b'

¿øÇÏ´Â ¼ø¼­¸¦ ¾òÀ¸·Á¸é »ç¿ëÀÚ Á¤ÀÇ Á¶ÇÕ ¼ø¼­·Î µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇØ¾ß ÇÕ´Ï´Ù. À̸¦ À§Çؼ­´Â »ùÇà Á¶ÇÕ ¼ø¼­°¡ sqle850a.h include ÆÄÀÏ·Î DB2¿¡ Á¦°øµÇ¾î¾ß ÇÕ´Ï´Ù. sqle850a.hÀÇ ³»¿ëÀº ±×¸² 25¿¡ ³ª¿Í ÀÖ½À´Ï´Ù.

±×¸² 25. »ç¿ëÀÚ Á¤ÀÇ Á¶ÇÕ ¼ø¼­ - sqle_850_500

#ifndef SQL_H_SQLE850A
#define SQL_H_SQLE850A
 
#ifdef __cplusplus
extern "C" {
#endif
 
unsigned char sqle_850_500[256] = {
0x00,0x01,0x02,0x03,0x37,0x2d,0x2e,0x2f,0x16,0x05,0x25,0x0b,0x0c,0x0d,0x0e,0x0f,
0x10,0x11,0x12,0x13,0x3c,0x3d,0x32,0x26,0x18,0x19,0x3f,0x27,0x1c,0x1d,0x1e,0x1f,
0x40,0x4f,0x7f,0x7b,0x5b,0x6c,0x50,0x7d,0x4d,0x5d,0x5c,0x4e,0x6b,0x60,0x4b,0x61,
0xf0,0xf1,0xf2,0xf3,0xf4,0xf5,0xf6,0xf7,0xf8,0xf9,0x7a,0x5e,0x4c,0x7e,0x6e,0x6f,
0x7c,(0xc1),(0xc2),0xc3,0xc4,0xc5,0xc6,0xc7,0xc8,0xc9,0xd1,0xd2,0xd3,0xd4,0xd5,0xd6,
0xd7,0xd8,0xd9,0xe2,0xe3,0xe4,0xe5,0xe6,0xe7,0xe8,0xe9,0x4a,0xe0,0x5a,0x5f,0x6d,
0x79,(0x81),(0x82),0x83,0x84,0x85,0x86,0x87,0x88,0x89,0x91,0x92,0x93,0x94,0x95,0x96,
0x97,0x98,0x99,0xa2,0xa3,0xa4,0xa5,0xa6,0xa7,0xa8,0xa9,0xc0,0xbb,0xd0,0xa1,0x07,
0x68,0xdc,0x51,0x42,0x43,0x44,0x47,0x48,0x52,0x53,0x54,0x57,0x56,0x58,0x63,0x67,
0x71,0x9c,0x9e,0xcb,0xcc,0xcd,0xdb,0xdd,0xdf,0xec,0xfc,0x70,0xb1,0x80,0xbf,0xff,
0x45,0x55,0xce,0xde,0x49,0x69,0x9a,0x9b,0xab,0xaf,0xba,0xb8,0xb7,0xaa,0x8a,0x8b,
0x2b,0x2c,0x09,0x21,0x28,0x65,0x62,0x64,0xb4,0x38,0x31,0x34,0x33,0xb0,0xb2,0x24,
0x22,0x17,0x29,0x06,0x20,0x2a,0x46,0x66,0x1a,0x35,0x08,0x39,0x36,0x30,0x3a,0x9f,
0x8c,0xac,0x72,0x73,0x74,0x0a,0x75,0x76,0x77,0x23,0x15,0x14,0x04,0x6a,0x78,0x3b,
0xee,0x59,0xeb,0xed,0xcf,0xef,0xa0,0x8e,0xae,0xfe,0xfb,0xfd,0x8d,0xad,0xbc,0xbe,
0xca,0x8f,0x1b,0xb9,0xb6,0xb5,0xe1,0x9d,0x90,0xbd,0xb3,0xda,0xfa,0xea,0x3e,0x41
};
#ifdef __cplusplus
}
#endif
 
#endif /* SQL_H_SQLE850A */

ÄÚµå ÆäÀÌÁö 850 ¹®ÀÚ¿¡¼­ ÄÚµå ÆäÀÌÁö 500 2Áø ÁýÇÕÀ» ¾ò´Â ¹æ¹ýÀ» º¸·Á¸é sqle_850_500ÀÇ »ùÇà Á¶ÇÕ ¼ø¼­¸¦ Á¡°ËÇϽʽÿÀ. °¢ ÄÚµå ÆäÀÌÁö 850 ¹®ÀÚ¿¡ ´ëÇØ Á¶ÇÕ ¼ø¼­¿¡¼­ÀÇ ±× °¡ÁßÄ¡´Â ´ÜÁö ÄÚµå ÆäÀÌÁö 500ÀÇ ÇØ´ç ÄÚµå Æ÷ÀÎÆ®ÀÔ´Ï´Ù.

¿¹¸¦ µé¾î, 'a' ¹®ÀÚ¸¦ °í·ÁÇØº¸½Ê½Ã¿À. ±×¸² 27°ú °°ÀÌ ÄÚµå ÆäÀÌÁö 850¿¡¼­ ÀÌ ¹®ÀÚÀÇ ÄÚµå Æ÷ÀÎÆ®´Â X'61'ÀÔ´Ï´Ù. sqle_850_500 ¹è¿­¿¡¼­ 'a' ¹®ÀÚ¿¡´Â X'81'ÀÇ °¡ÁßÄ¡°¡ ÇÒ´çµÇ¾ú½À´Ï´Ù(Áï, sqle_850_500 ¹è¿­ÀÇ 98¹øÂ° ±¸¼º¿ä¼Ò).

À§ÀÇ »ùÇà »ç¿ëÀÚ Á¤ÀÇ Á¶ÇÕ ¼ø¼­·Î µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇÒ ¶§ ³× ¹®ÀÚÀÇ Á¶ÇÕ ¹æ¹ýÀ» °í·ÁÇØº¸½Ê½Ã¿À.

¹®ÀÚ
ÄÚµå ÆäÀÌÁö 850 ÄÚµå Æ÷ÀÎÆ® / °¡ÁßÄ¡(sqle_850_500¿¡¼­)
'a'
X'61' / X'81'
'b'
X'62' / X'82'
'A'
X'41' / X'C1'
'B'
X'42' / X'C2'

°¡ÁßÄ¡¿¡ µû¸¥ ÄÚµå ÆäÀÌÁö 850 »ç¿ëÀÚ Á¤ÀÇ Á¶ÇÕ(¿øÇÏ´Â Á¶ÇÕ)Àº ´ÙÀ½°ú °°½À´Ï´Ù.

    'a' < 'b' < 'A' < 'B'

ÀÌ ¿¹¿¡¼­ ¿øÇÏ´Â ¼öÇàÀ» ½Ã¹Ä·¹ÀÌÆ®Çϵµ·Ï ¿Ã¹Ù¸¥ °¡ÁßÄ¡¸¦ ÁöÁ¤ÇÏ¿© ¿øÇÏ´Â Á¶ÇÕÀ» ¾ò°Ô µË´Ï´Ù.

½ÇÁ¦ Á¶ÇÕ ¼ø¼­¸¦ ¸é¹ÐÈ÷ °üÂûÇÏ¸é ¼ø¼­ ÀÚü´Â ´Ü¼øÈ÷ º¯È¯Ç¥¶ó´Â °ÍÀ» ¾Ë ¼ö ÀÖ½À´Ï´Ù. ÀÌ º¯È¯Ç¥¿¡¼­ ¼Ò½º ÄÚµå ÆäÀÌÁö´Â µ¥ÀÌÅÍ ±â¹Ý(850)ÀÇ ÄÚµå ÆäÀÌÁöÀÌ°í ¸ñÇ¥ ÄÚµå ÆäÀÌÁö´Â ¿øÇÏ´Â 2Áø Á¶ÇÕ ÄÚµå ÆäÀÌÁö(500)ÀÔ´Ï´Ù. DB2¿¡¼­ Á¦°øÇÏ´Â ´Ù¸¥ »ùÇà Á¶ÇÕ ¼ø¼­¸¦ »ç¿ëÇÏ¸é ´Ù¸¥ º¯È¯À» ¾òÀ» ¼ö ÀÖ½À´Ï´Ù. »ç¿ëÀÚ°¡ ¿ä±¸ÇÏ´Â º¯È¯Ç¥°¡ DB2¿¡ ÀÖÁö ¾ÊÀ» °æ¿ì IBM Ã¥ Character Data Representation Architecture, Reference and Registry SC09-2190¿¡¼­ Ãß°¡ º¯È¯Ç¥¸¦ ã¾Æº¼ ¼ö ÀÖ½À´Ï´Ù. ÀÌ Ã¥°ú ÇÔ²² Á¦°øµÇ´Â CD-ROM¿¡¼­ Ãß°¡ º¯È¯Ç¥¸¦ ãÀ» ¼ö ÀÖ½À´Ï´Ù.

Á¶ÇÕ ¼ø¼­¿¡ ´ëÇØ¼­´Â Á¶ÇÕ ¼ø¼­ °³¿ä¿¡¼­ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ. ¶ÇÇÑ DB2¿¡ ÀÖ´Â Á¶ÇÕ ¼ø¼­¿¡ ´ëÇØ¼­, ±×¸®°í »ç¿ëÀÚ Á¤ÀÇ Á¶ÇÕ ¼ø¼­·Î µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇÏ´Â µ¥¸ð¸¦ ³ªÅ¸³»´Â »ùÇà ÇÁ·Î±×·¥ÀÇ ¸ñ·Ï(db_udcs.c)¿¡ ´ëÇØ¼­´Â Administrative API Reference¿¡ ¼³¸íµÈ CREATE DATABASE API¸¦ ÂüÁ¶ÇϽʽÿÀ.

±×¸² 26. ÄÚµå ÆäÀÌÁö 500

CP00500

±×¸² 27. ÄÚµå ÆäÀÌÁö 850

CP00850

 


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]