CHAR関数ã?«ã‚ˆã‚Šå›ºå®šé•·ã?®æ–‡å—列ã?¸ã?®å¤‰æ?›å€¤ã?Œè¿”ã?•れã?¾ã?™ã€‚
行�れる変��以下���り��。
- æ–‡å—列変æ?› 一ã?¤ç›®ã?®å¼•æ•°ã?Œæ–‡å—列ã?§ã?‚ã‚‹å ´å?ˆã?§ã?™ã€‚
- 日時変æ?› 一ã?¤ç›®ã?®å¼•æ•°ã?Œæ—¥ä»˜ã€?時刻ã€?タイムスタンプã?§ã?‚ã‚‹å ´å?ˆã?§ã?™ã€‚
- å°?数変æ?› 一ã?¤ç›®ã?®å¼•æ•°ã?Œå°?æ•°ã?§ã?‚ã‚‹å ´å?ˆã?§ã?™ã€‚
- å€?精度浮動å°?数点数変æ?› 一ã?¤ç›®ã?®å¼•æ•°ã?ŒDOUBLEã?‚ã‚‹ã?„ã?¯REALã?§ã?‚ã‚‹å ´å?ˆã?§ã?™ã€‚
- 整数変æ?› 一ã?¤ç›®ã?®å¼•æ•°ã?ŒSMALLINTã€?INTEGERã€?BIGINTã?§ã?‚ã‚‹å ´å?ˆã?§ã?™ã€‚
一ã?¤ç›®ã?®å¼•æ•°ã?¯ã€?ã??ã?®åž‹ã?Œçµ„è¾¼ã?¿ã?®ãƒ‡ãƒ¼ã‚¿åž‹ã?§ã?‚ã‚‹å¿…è¦?ã?Œã?‚りã?¾ã?™ã€‚CHAR関数ã?®è¿”り値ã?¯å›ºå®šé•·ã?®æ–‡å—列ã?§ã?™ã€‚一ã?¤ç›®ã?®å¼•æ•°ã?¯NULLã?¨ã?™ã‚‹ã?“ã?¨ã?Œã?§ã??ã€?ã??ã?®å ´å?ˆã?¯è¿”り値ã?¯NULLã?§ã?™ã€‚一ã?¤ç›®ã?®å¼•æ•°ã?¯ã€?ã??ã?®åž‹ã?ŒXMLã?§ã?‚ã?£ã?¦ã?¯ã?ªã‚Šã?¾ã?›ã‚“。もã?—XMLã?®å€¤ã‚’固定長ã?®CHARã?«ã?—ã?Ÿã?„ã?®ã?ªã‚‰ã€?SQL/XML直列化演算å?ã?®XMLSERIALIZEを使ã?†å¿…è¦?ã?Œã?‚りã?¾ã?™ã€‚
æ–‡å—ã?‹ã‚‰æ–‡å—ã?¸ã?®å¤‰æ?›ã‚’行ã?†æ™‚ã?®æ›¸ã??æ–¹
CHAR (æ–‡å—å¼? [, æ•°] )
- æ–‡å—å¼?
- CHAR�VARCHAR�LONG VARCHAR�CLOB���れ��データ型�値を返��。
- æ•°
- è¿”å?´ã?•れる固定長文å—列ã?®é•·ã?•。値ã?¯0ã?‹ã‚‰254ã?®é–“ã?§ã?ªã?‘れã?°ã?ªã‚‰ã?ªã?„。
ã‚‚ã?—æ–‡å—å¼?ã?®é•·ã?•ã?Œæ•°ã‚ˆã‚Šã‚‚å°?ã?•ã?‹ã?£ã?Ÿå ´å?ˆã€?é•·ã?•ã?Œæ•°ã?¨ç‰ã?—ã??ã?ªã‚‹ã‚ˆã?†ã€?関数ã?®çµ?æžœã?¯ç©ºç™½ã?«ã‚ˆã‚Šã?¤ã‚?られã?¾ã?™ã€‚ã‚‚ã?—æ–‡å—å¼?ã?®é•·ã?•ã?Œæ•°ã‚ˆã‚Šå¤§ã??ã?‹ã?£ã?Ÿå ´å?ˆã€?切æ?¨ã?¦ã?Œè¡Œã‚?れã?¾ã?™ã€‚ã‚‚ã?—空白以外ã?®æ–‡å—ã?Œåˆ‡ã‚Šæ?¨ã?¦ã‚‰ã‚Œã€?æ–‡å—å¼?ã?Œé•·ã?„æ–‡å—列(LONG VARCHARã‚„CLOB)ã?§ã?ªã?‘れã?°ã€?è¦å‘Šã?Œè¿”ã?•れã?¾ã?™ã€‚
æ•´æ•°ã?‹ã‚‰æ–‡å—ã?¸ã?®å¤‰æ?›ã‚’行ã?†ã?¨ã??ã?®æ›¸ã??æ–¹
CHAR (æ•´æ•°å¼? )
- æ•´æ•°å¼?
- 整数�データ型(SMALLINT�INTEGER�BIGINT)型�値を返��
関数ã?®çµ?æžœã?¯ã€?SQLã?®æ•´æ•°ã?¨ã?—ã?¦æ¸¡ã?•れã?Ÿå¼•æ•°ã‚’æ–‡å—列ã?§è¡¨ç?¾ã?—ã?Ÿã‚‚ã?®ã?¨ã?ªã‚Šã?¾ã?™ã€‚çµ?æžœã?¯å¼•æ•°ã?®æ•°ã‚’10進ã?§è¡¨ã?™næ–‡å—ã?Šã‚ˆã?³ã€?ã‚‚ã?—引数ã?Œè² æ•°ã?§ã?‚ã?£ã?Ÿã?ªã‚‰è² ã?®ç¬¦å?·ã?‹ã‚‰æ§‹æˆ?ã?•れã?¾ã?™ã€‚ã?¾ã?Ÿçµ?æžœã?¯å·¦è©°ã‚?ã?•れã?¦ã?„ã?¾ã?™ã€‚
- ã‚‚ã?—一ã?¤ç›®ã?®å¼•æ•°ã?ŒSMALLINTã?ªã‚‰ã€?çµ?æžœã?®æ–‡å—列ã?®é•·ã?•ã?¯6ã?§ã?™ã€‚ã‚‚ã?—çµ?æžœã?«ã?¦æ•°å€¤ã?®æ–‡å—æ•°ã?Œ6ã?«æº€ã?Ÿã?ªã?„å ´å?ˆã?¯ã€?6æ–‡å—ã?¨ã?ªã‚‹ã‚ˆã?†å?³å?´ã?«ç©ºç™½ã?Œè©°ã‚?られã?¾ã?™ã€‚
- ã‚‚ã?—一ã?¤ç›®ã?®å¼•æ•°ã?ŒINTEGERã?ªã‚‰ã€?çµ?æžœã?®æ–‡å—列ã?®é•·ã?•ã?¯11ã?§ã?™ã€‚ã‚‚ã?—çµ?æžœã?«ã?¦æ•°å€¤ã?®æ–‡å—æ•°ã?Œ11ã?«æº€ã?Ÿã?ªã?„å ´å?ˆã?¯ã€?11æ–‡å—ã?¨ã?ªã‚‹ã‚ˆã?†å?³å?´ã?«ç©ºç™½ã?Œè©°ã‚?られã?¾ã?™ã€‚
- ã‚‚ã?—一ã?¤ç›®ã?®å¼•æ•°ã?ŒBIGINTã?ªã‚‰ã€?çµ?æžœã?®æ–‡å—列ã?®é•·ã?•ã?¯20ã?§ã?™ã€‚ã‚‚ã?—çµ?æžœã?«ã?¦æ•°å€¤ã?®æ–‡å—æ•°ã?Œ20ã?«æº€ã?Ÿã?ªã?„å ´å?ˆã?¯ã€?20æ–‡å—ã?¨ã?ªã‚‹ã‚ˆã?†å?³å?´ã?«ç©ºç™½ã?Œè©°ã‚?られã?¾ã?™ã€‚
日時ã?‹ã‚‰æ–‡å—ã?¸ã?®å¤‰æ?›ã‚’行ã?†ã?¨ã??ã?®æ›¸ã??æ–¹
CHAR (日時� )
- 日時�
- ��次�データ型�何れ���。
- 日付: çµ?æžœã?¯æ—¥ä»˜ã‚’表ã?™æ–‡å—表ç?¾ã?§ã?™ã€‚çµ?æžœã?®é•·ã?•ã?¯10ã?§ã?™ã€‚
- 時刻: çµ?æžœã?¯æ™‚刻を表ã?™æ–‡å—表ç?¾ã?§ã?™ã€‚çµ?æžœã?®é•·ã?•ã?¯8ã?§ã?™ã€‚
- タイムスタンプ: çµ?æžœã?¯ã‚¿ã‚¤ãƒ スタンプを表ã?™æ–‡å—表ç?¾ã?§ã?™ã€‚çµ?æžœã?®é•·ã?•ã?¯26ã?§ã?™ã€‚
å°?æ•°ã?‹ã‚‰æ–‡å—ã?¸ã?®å¤‰æ?›ã‚’行ã?†ã?¨ã??ã?®æ›¸ã??æ–¹
CHAR (å°?æ•°å¼? )
- å°?æ•°å¼?
- å°?æ•°ã?®ãƒ‡ãƒ¼ã‚¿åž‹ã‚’è¿”ã?™å¼?ã?§ã?™ã€‚ã‚‚ã?—精度や目盛りã?®å¤‰æ›´ã‚’行ã?†å ´å?ˆã?¯ã€?æ–‡å—ã?¸ã?®å¤‰æ?›ã‚’行ã?†å‰?ã?«DECIMALã?¨ã?„ã?†ã‚¹ã‚«ãƒ©ãƒ¼é–¢æ•°ã?«ã‚ˆã‚Šå¤‰æ›´ã?—ã?¦ã??ã? ã?•ã?„。
浮動å°?数点数ã?‹ã‚‰æ–‡å—ã?¸ã?®å¤‰æ?›ã‚’行ã?†ã?¨ã??ã?®æ›¸ã??æ–¹
CHAR (浮動�数点数� )
- 浮動�数点数�
- 浮動�数点数�データ型(DOUBLEやREAL)�値を返����。
CHAR関数ã?«ã‚ˆã‚ŠEDLEVEL(smallintåž‹ã?¨å®šç¾©ã?•れã?¦ã?„ã‚‹ã?¨ã?—ã?¾ã?™ã€‚)ã?®å€¤ã‚’ã€?固定長ã?®æ–‡å—列ã?¨ã?—ã?¦è¿”ã?—ã?¾ã?™ã€‚
SELECT CHAR(EDLEVEL) FROM EMPLOYEE
EDLEVELã?Œ18ã?¨ã?™ã‚‹ã?ªã‚‰ã€?ã??ã?®å€¤ã?ŒCHAR(6)åž‹ã?§'18    'ã?¨è¿”ã?•れã?¾ã?™ã€‚(18ã?«ç©ºç™½ã?Œ4ã?¤ç¶šã??ã?¾ã?™ã€‚)