連çµ?演算å?ã?®||ã?«ã‚ˆã‚Šã€?å?³è¾ºã?®ã‚ªãƒšãƒ©ãƒ³ãƒ‰ã?Œå·¦è¾ºã?®ã‚ªãƒšãƒ©ãƒ³ãƒ‰ã?®æœ«å°¾ã?«é€£çµ?ã?•れã?¾ã?™ã€‚ã?“ã?®æ¼”ç®—å?ã?¯æ–‡å—やビットã?®å¼?ã?«ä½œç”¨ã?—ã?¾ã?™ã€‚
å…¨ã?¦ã?®çµ„ã?¿è¾¼ã?¿ã?®ãƒ‡ãƒ¼ã‚¿åž‹ã?¯æš—黙裡ã?«æ–‡å—列ã?«å¤‰æ?›ã?•れるã?®ã?§ã€?ã?“ã?®é–¢æ•°ã?¯å…¨ã?¦ã?®çµ„ã?¿è¾¼ã?¿ã?®ãƒ‡ãƒ¼ã‚¿åž‹ã?«ä½œç”¨ã?—ã?¾ã?™ã€‚
{ { æ–‡å—å¼? || æ–‡å—å¼? } | { ビットå¼? || ビットå¼? } }
æ–‡å—å¼?ã?®å ´å?ˆã€?ã‚‚ã?—å?³è¾ºã?¨å·¦è¾ºã?®ã‚ªãƒšãƒ©ãƒ³ãƒ‰ã?®åž‹ã?Œã?©ã?¡ã‚‰ã‚‚CHARã?§ã?‚れã?°ã€?連çµ?ã?—ã?Ÿçµ?æžœã?¯CHARã?§ã€?ã??ã?†ã?§ã?ªã?„ã?ªã‚‰é€£çµ?ã?—ã?Ÿçµ?æžœã?¯VARCHARã?§ã?™ã€‚ CHARã‚„VARCHARã?«ã?¦ä¸€èˆ¬çš„ã?ªã€?空白詰や値ã?®ãƒˆãƒªãƒ ã?Œã€?ã?“ã?®æ¼”ç®—å?ã?®çµ?æžœã?«ã?¦é?©ç”¨ã?•れã?¾ã?™ã€‚
çµ?果文å—列ã?®é•·ã?•ã?¯ä¸¡æ–¹ã?®ã‚ªãƒšãƒ©ãƒ³ãƒ‰ã?®é•·ã?•ã?®å’Œã?§ã?™ã€‚
ビット列ã?«ã?¤ã?„ã?¦ã?¯ã€?ã‚‚ã?—å?³è¾ºã?¨å·¦è¾ºã?®ã‚ªãƒšãƒ©ãƒ³ãƒ‰ã?®åž‹ã?Œã?©ã?¡ã‚‰ã‚‚CHAR FOR BIT DATAã?§ã?‚れã?°ã€?連çµ?ã?—ã?Ÿçµ?æžœã?¯CHAR FOR BIT DATAã?§ã€?ã??ã?†ã?§ã?ªã?„ã?ªã‚‰é€£çµ?ã?—ã?Ÿçµ?æžœã?¯VARCHAR FOR BIT DATAã?§ã?™ã€‚
--返り値�'supercalifragilisticexbealidocious(sp?)'��。 VALUES 'supercalifragilistic' || 'exbealidocious' || '(sp?)' -- NULLを返���。 VALUES CAST (null AS VARCHAR(7))|| 'AString' -- '130asdf'を返���。 VALUES '130' || 'asdf'