°ü¸® ¹× »ç¿ëÀÚ ¾È³»¼
µ¥ÀÌÅ͸¦ BLOB, ºñÆ® µ¥ÀÌÅÍ¿ë ¶Ç´Â µ¥ÀÌÅÍ ¸µÅ© °ª°ú °°Àº ÀÌÁø µ¥ÀÌÅÍ À¯ÇüÀ» °®´Â Ä÷³¿¡ ÀúÀåÇÒ °æ¿ì, DB2´Â µ¥ÀÌÅ͸¦ º¯È¯ÇÏÁö ¾Ê½À´Ï´Ù. µÎ °³ÀÇ ´Ù¸¥ ÄÚµå ÆäÀÌÁö·Î ÅØ½ºÆ® À妽º¸¦ ÀÛ¼ºÇÏ´Â °æ¿ì ¹®Á¦Á¡ÀÌ ¹ßÇàÇÒ ¼ö ÀÖÀ¸¹Ç·Î ¹®¼´Â ¿øº» ÄÚµå ÆäÀÌÁö(CCSID)¸¦ º¸À¯ÇÕ´Ï´Ù. ±×·¯¹Ç·Î, µ¥ÀÌÅͺ£À̽ºÀÇ ÄÚµå ÆäÀÌÁö¸¦ »ç¿ëÇÒ °ÍÀÎÁö CREATE INDEX ¸í·É¿¡ ÁöÁ¤µÈ ÄÚµå ÆäÀÌÁö¸¦ »ç¿ëÇÒ °ÍÀÎÁö¸¦ °áÁ¤ÇØ¾ß ÇÕ´Ï´Ù.
ÀÌ·¯ÇÑ ¹®Á¦Á¡À» ¹æÁöÇÏ·Á¸é ÅØ½ºÆ® À妽º¸¦ ÀÛ¼ºÇÒ ¶§ ÄÚµå ÆäÀÌÁö¸¦ ÁöÁ¤ÇϽʽÿÀ.
db2text CREATE INDEX db2ext.comment FOR TEXT ON db2ext.texttab (comment) CCSID 1252
ÄÚµå ÆäÀÌÁö¸¦ ÁöÁ¤ÇÏÁö ¾ÊÀº °æ¿ì, ´ÙÀ½ ¸í·ÉÀ» È£ÃâÇÏ¿© À妽º¸¦ ÀÛ¼ºÇÒ ¶§ »ç¿ëÇß´ø CCSID¸¦ ¼±ÅÃÇϽʽÿÀ.
db2 SELECT ccsid FROM db2ext.textindexes WHERE INDNAME = 'COMMENT' and INDSCHEMA = 'DB2EXT'
ÇϳªÀÇ ÅØ½ºÆ® À妽º¿¡¼ ´Ù¸¥ ÄÚµå ÆäÀÌÁö¸¦ Æ÷ÇÔÇÏ´Â ¹®¼¸¦ Áö¿øÇÏÁö ¾Ê½À´Ï´Ù. DB2°¡ ¹®¼ ÄÚµå ÆäÀÌÁö ¼³Á¤À» º¯È¯ÇÏ´Â ¹æ¹ý¿¡ ´ëÇÑ Á¤º¸´Â DB2 Universal Database °ü¸® ¾È³»¼¸¦ ÂüÁ¶ÇϽʽÿÀ. °ü·Ã Á¤º¸¸¦ ÂüÁ¶ÇϽʽÿÀ.
¹®ÀÚ µ¥ÀÌÅÍ À¯Çü¿¡ ´ëÇÑ À妽º¸¦ ÀÛ¼ºÇÒ ¶§¿¡´Â ÀÌ·¯ÇÑ ¹®Á¦Á¡ÀÌ ¾ø½À´Ï´Ù.