RAW
You use the RAW datatype to store binary data or byte strings (a sequence of graphics characters, for example). RAW data is not interpreted by Oracle8i. The RAW datatype takes a required parameter that lets you specify a maximum width up to 255 bytes. The syntax follows: RAW(maximum_width)You cannot use a constant or variable to specify the maximum width; you must use an integer literal. RAW data is like CHAR data, except that Oracle8i assumes nothing about the meaning of RAW data and does no character set conversions (from 7-bit ASCII to EBCDIC Code Page 500 for example) when you transmit RAW data from one system to another.
Table 4-1 Internal datatypes
Name Code Description
CHAR 96 <= 2000-byte, fixed-length string
NCHAR 96 <= 2000-byte, fixed-length single-byte or fixed-width multi-byte string
DATE 12 7-byte, fixed-length date/time value
LONG 8 <= 2147483647-byte, variable-length string
LONG RAW 24 <= 2147483647-byte, variable-length binary data
NUMBER 2 fixed or floating point number, represented in binary coded decimal format
RAW 23 <= 255-byte, variable-length binary data
ROWID 11 fixed-length binary value
VARCHAR2 1 <= 4000-byte, variable-length string
NVARCHAR2 1 <= 4000-byte, variable-length single-byte or fixed-width multi-byte string
You use the RAW datatype to store binary data or byte strings (a sequence of graphics characters, for example). RAW data is not interpreted by Oracle8i. The RAW datatype takes a required parameter that lets you specify a maximum width up to 255 bytes. The syntax follows: RAW(maximum_width)You cannot use a constant or variable to specify the maximum width; you must use an integer literal. RAW data is like CHAR data, except that Oracle8i assumes nothing about the meaning of RAW data and does no character set conversions (from 7-bit ASCII to EBCDIC Code Page 500 for example) when you transmit RAW data from one system to another.
Table 4-1 Internal datatypes
Name Code Description
CHAR 96 <= 2000-byte, fixed-length string
NCHAR 96 <= 2000-byte, fixed-length single-byte or fixed-width multi-byte string
DATE 12 7-byte, fixed-length date/time value
LONG 8 <= 2147483647-byte, variable-length string
LONG RAW 24 <= 2147483647-byte, variable-length binary data
NUMBER 2 fixed or floating point number, represented in binary coded decimal format
RAW 23 <= 255-byte, variable-length binary data
ROWID 11 fixed-length binary value
VARCHAR2 1 <= 4000-byte, variable-length string
NVARCHAR2 1 <= 4000-byte, variable-length single-byte or fixed-width multi-byte string
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货