VARCHARã?§ã?¯æ–‡å—列を記録ã?™ã‚‹å?¯å¤‰é•·ã?®é ˜åŸŸã?Œæ??ä¾›ã?•れã?¾ã?™ã€‚
{ VARCHAR | CHAR VARYING | CHARACTER VARYING }(é•·ã?•)
é•·ã?•ã?¯ç¬¦å?·ã?®ã?ªã?„æ•´æ•°ã?®å®šæ•°ã?§ã?™ã€‚ æ–‡å—列ã?®é•·ã?•ã?¯é•·ã?•ã?®å€¤ã‚„ã€?java.lang.Integer.MAX_VALUEより大ã??ã?ªå€¤ã?§ã?‚ã?£ã?¦ã?¯ã?ªã‚Šã?¾ã?›ã‚“。
VARCHARã?®æ–‡å—列ã?®æœ€å¤§é•·ã?¯32,672æ–‡å—ã?§ã?™ã€‚
java.lang.String
VARCHAR
Derby ã?¯æŒ‡å®šã?•れã?Ÿé•·ã?•ã?«æº€ã?Ÿã?ªã?„VARCHARã?®å€¤ã‚’æ–‡å—è©°ã‚?ã?—ã?¾ã?›ã‚“。 Derbyã?¯VARCHARã?§æŒ‡å®šã?•れã?Ÿã‚ˆã‚Šå¤§ã??ã?ªæ–‡å—æ•°ã?®å€¤ã?Œä¸Žã?ˆã‚‰ã‚Œã?Ÿå ´å?ˆã€?æ–‡å—列ã?‹ã‚‰ç©ºç™½ã‚’切りæ?¨ã?¦ã?¾ã?™ã€‚ 空白以外ã?®æ–‡å—ã?¯åˆ‡ã‚Šæ?¨ã?¦ã‚‰ã‚Œã?ªã?„ã?®ã?§ã€?例外ã?ŒæŒ™ã?Œã‚‹åŽŸå› ã?¨ã?ªã‚Šã?¾ã?™ã€‚ VARCHARã?«å¯¾ã?—ã?¦æ¯”較演算å?ã?Œé?©ç”¨ã?•れã?Ÿå ´å?ˆã€?オペランドã?®é•·ã?•ã?Œå¤‰ã‚?ã‚‹ã?“ã?¨ã?¯ã?‚りã?¾ã?›ã‚“ã?Œã€?値ã?®æœ«å°¾ã?«ã?‚る空白ã?¯ç„¡è¦–ã?•れã?¾ã?™ã€‚
一ã?¤ã?®å¼?ã?«ã?¦CHARã‚„VARCHARã?Œæ··åœ¨ã?—ã?¦ä½¿ã‚?れã?Ÿå ´å?ˆã€?æ–‡å—列長ã?®çŸã?„値ã?¯æ–‡å—列長ã?®é•·ã?„値ã?«å?ˆã‚?ã?›ã?¦ã€?空白文å—ã?§æ–‡å—è©°ã‚?ã?•れã?¾ã?™ã€‚
æ–‡å—列定数ã?®åž‹ã?¯VARCHARã?§ã?¯ã?ªã??CHARã?§ã?™ã€‚