DB2¸¦ »ç¿ëÇÏ¿©, »ç¿ëÀÚ Á¤ÀÇ Á¶ÇÕ ¼ø¼¿¡ µû¶ó ¹®ÀÚ¿À» Á¶ÇÕÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ·± ±â´ÉÀ» »ç¿ëÇÏ¿© EBCDIC 2Áø Á¶ÇÕÀ» ½Ã¹Ä·¹ÀÌÆ®ÇÒ ¼ö ÀÖ½À´Ï´Ù.
EBCDIC Á¶ÇÕÀ» ½Ã¹Ä·¹ÀÌÆ®ÇÏ´Â ÇÑ ¿¹·Î, ÄÚµå ÆäÀÌÁö 850À¸·Î ASCII µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇÏ·Á ÇÏÁö¸¸ ¸¶Ä¡ µ¥ÀÌÅͰ¡ ½ÇÁ¦·Î ÄÚµå ÆäÀÌÁö 500ÀÇ EBCDIC µ¥ÀÌÅͺ£À̽º ÀÖ´Â °Íó·³ ¹®ÀÚ¿À» Á¶ÇÕÇÏ·Á ÇÑ´Ù°í °¡Á¤Çغ¾½Ã´Ù. ÄÚµå ÆäÀÌÁö 500ÀÇ Á¤ÀÇ¿¡ ´ëÇØ¼´Â ±×¸² 26, ÄÚµå ÆäÀÌÁö 850¿¡ ´ëÇØ¼´Â ±×¸² 27¿¡¼ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.
2ÁøÀ¸·Î Á¶ÇÕÇÒ ¶§ EBCDIC ÄÚµå ÆäÀÌÁö 500 µ¥ÀÌÅͺ£À̽º¿¡ ÀÖ´Â ³× ¹®ÀÚÀÇ »ó´ë Á¶ÇÕÀ» °í·ÁÇØº¸½Ê½Ã¿À.
ÄÚµå ÆäÀÌÁö 500 2Áø Á¶ÇÕ ¼ø¼(¿øÇÏ´Â ¼ø¼)´Â ´ÙÀ½°ú °°½À´Ï´Ù.
'a' < 'b' < 'A' < 'B'
ASCII ÄÚµå ÆäÀÌÁö 850À¸·Î µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇÒ °æ¿ì 2Áø Á¶ÇÕÀº ´ÙÀ½°ú °°Àº °á°ú¸¦ ³º½À´Ï´Ù.
ÄÚµå ÆäÀÌÁö 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 »ç¿ëÀÚ Á¤ÀÇ Á¶ÇÕ(¿øÇÏ´Â Á¶ÇÕ)Àº ´ÙÀ½°ú °°½À´Ï´Ù.
'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¸¦ ÂüÁ¶ÇϽʽÿÀ.