아래는 메뉴얼에 나온 각 타입 입니다.
<H3>7.3.2 Numeric types</H3>
<TABLE BORDER WIDTH="80%" NOSAVE >
<TR><TD><STRONG>Column type</STRONG> </TD><TD> <STRONG>Storage required</STRONG>
</TR NOSAVE>
<TR><TD><CODE>TINYINT</CODE> </TD><TD> 1 byte
</TR NOSAVE>
<TR><TD><CODE>SMALLINT</CODE> </TD><TD> 2 bytes
</TR NOSAVE>
<TR><TD><CODE>MEDIUMINT</CODE> </TD><TD> 3 bytes
</TR NOSAVE>
<TR><TD><CODE>INT</CODE> </TD><TD> 4 bytes
</TR NOSAVE>
<TR><TD><CODE>INTEGER</CODE> </TD><TD> 4 bytes
</TR NOSAVE>
<TR><TD><CODE>BIGINT</CODE> </TD><TD> 8 bytes
</TR NOSAVE>
<TR><TD><CODE>FLOAT(X)</CODE> </TD><TD> 4 if X <= 24 or 8 if 25 <= X <= 53
</TR NOSAVE>
<TR><TD><CODE>FLOAT</CODE> </TD><TD> 4 bytes
</TR NOSAVE>
<TR><TD><CODE>DOUBLE</CODE> </TD><TD> 8 bytes
</TR NOSAVE>
<TR><TD><CODE>DOUBLE PRECISION</CODE> </TD><TD> 8 bytes
</TR NOSAVE>
<TR><TD><CODE>REAL</CODE> </TD><TD> 8 bytes
</TR NOSAVE>
<TR><TD><CODE>DECIMAL(M,D)</CODE> </TD><TD> <CODE>M</CODE> bytes (<CODE>D</CODE>+2, if <CODE>M < D</CODE>)
</TR NOSAVE>
<TR><TD><CODE>NUMERIC(M,D)</CODE> </TD><TD> <CODE>M</CODE> bytes (<CODE>D</CODE>+2, if <CODE>M < D</CODE>)
</TR>
</TABLE>
<H3>7.3.3 Date and time types</H3>
<TABLE BORDER WIDTH="80%" NOSAVE >
<TR><TD><STRONG>Column type</STRONG> </TD><TD> <STRONG>Storage required</STRONG>
</TR NOSAVE>
<TR><TD><CODE>DATE</CODE> </TD><TD> 3 bytes
</TR NOSAVE>
<TR><TD><CODE>DATETIME</CODE> </TD><TD> 8 bytes
</TR NOSAVE>
<TR><TD><CODE>TIMESTAMP</CODE> </TD><TD> 4 bytes
</TR NOSAVE>
<TR><TD><CODE>TIME</CODE> </TD><TD> 3 bytes
</TR NOSAVE>
<TR><TD><CODE>YEAR</CODE> </TD><TD> 1 byte
</TR>
</TABLE>
<H3>7.3.4 String types</H3>
<TABLE BORDER WIDTH="80%" NOSAVE >
<TR><TD><STRONG>Column type</STRONG> </TD><TD> <STRONG>Storage required</STRONG>
</TR NOSAVE>
<TR><TD><CODE>CHAR(M)</CODE> </TD><TD> <CODE>M</CODE> bytes, <CODE>1 <= M <= 255</CODE>
</TR NOSAVE>
<TR><TD><CODE>VARCHAR(M)</CODE> </TD><TD> <CODE>L</CODE>+1 bytes, where <CODE>L <= M</CODE> and
<CODE>1 <= M <= 255</CODE>
</TR NOSAVE>
<TR><TD><CODE>TINYBLOB</CODE>, <CODE>TINYTEXT</CODE> </TD><TD> <CODE>L</CODE>+1 bytes,
where <CODE>L</CODE> < 2^8
</TR NOSAVE>
<TR><TD><CODE>BLOB</CODE>, <CODE>TEXT</CODE> </TD><TD> <CODE>L</CODE>+2 bytes,
where <CODE>L</CODE> < 2^16
</TR NOSAVE>
<TR><TD><CODE>MEDIUMBLOB</CODE>, <CODE>MEDIUMTEXT</CODE> </TD><TD> <CODE>L</CODE>+3 bytes,
where <CODE>L</CODE> < 2^24
</TR NOSAVE>
<TR><TD><CODE>LONGBLOB</CODE>, <CODE>LONGTEXT</CODE> </TD><TD> <CODE>L</CODE>+4 bytes,
where <CODE>L</CODE> < 2^32
</TR NOSAVE>
<TR><TD><CODE>ENUM('value1','value2',...)</CODE> </TD><TD> 1 or 2 bytes, depending on
the number of enumeration values (65535 values maximum)
</TR NOSAVE>
<TR><TD><CODE>SET('value1','value2',...)</CODE> </TD><TD> 1, 2, 3, 4 or 8 bytes, depending
on the number of set members (64 members maximum)
</TR>
</TABLE>
<h3>그리고. 아래는 Date/Time에대한 필드 설명임다.</h3>
<TABLE BORDER WIDTH="100%" NOSAVE >
<TR><TD><STRONG>Column type</STRONG> </TD><TD> <STRONG>``Zero'' value</STRONG>
</TR NOSAVE>
<TR><TD><CODE>DATETIME</CODE> </TD><TD> <CODE>'0000-00-00 00:00:00'</CODE>
</TR NOSAVE>
<TR><TD><CODE>DATE</CODE> </TD><TD> <CODE>'0000-00-00'</CODE>
</TR NOSAVE>
<TR><TD><CODE>TIMESTAMP</CODE> </TD><TD> <CODE>00000000000000</CODE> (length depends on display size)
</TR NOSAVE>
<TR><TD><CODE>TIME</CODE> </TD><TD> <CODE>'00:00:00'</CODE>
</TR NOSAVE>
<TR><TD><CODE>YEAR</CODE> </TD><TD> <CODE>0000</CODE>
</TR>
</TABLE>
<h3>또. 다른 데이타 베이스랑 비교표입니다.</h3>
<TABLE BORDER WIDTH="100%" NOSAVE >
<TR><TD><STRONG>Other vendor type</STRONG> </TD><TD> <STRONG>MySQL type</STRONG>
</TR NOSAVE>
<TR><TD><CODE>BINARY(NUM)</CODE> </TD><TD> <CODE>CHAR(NUM) BINARY</CODE>
</TR NOSAVE>
<TR><TD><CODE>CHAR VARYING(NUM)</CODE> </TD><TD> <CODE>VARCHAR(NUM)</CODE>
</TR NOSAVE>
<TR><TD><CODE>FLOAT4</CODE> </TD><TD> <CODE>FLOAT</CODE>
</TR NOSAVE>
<TR><TD><CODE>FLOAT8</CODE> </TD><TD> <CODE>DOUBLE</CODE>
</TR NOSAVE>
<TR><TD><CODE>INT1</CODE> </TD><TD> <CODE>TINYINT</CODE>
</TR NOSAVE>
<TR><TD><CODE>INT2</CODE> </TD><TD> <CODE>SMALLINT</CODE>
</TR NOSAVE>
<TR><TD><CODE>INT3</CODE> </TD><TD> <CODE>MEDIUMINT</CODE>
</TR NOSAVE>
<TR><TD><CODE>INT4</CODE> </TD><TD> <CODE>INT</CODE>
</TR NOSAVE>
<TR><TD><CODE>INT8</CODE> </TD><TD> <CODE>BIGINT</CODE>
</TR NOSAVE>
<TR><TD><CODE>LONG VARBINARY</CODE> </TD><TD> <CODE>MEDIUMBLOB</CODE>
</TR NOSAVE>
<TR><TD><CODE>LONG VARCHAR</CODE> </TD><TD> <CODE>MEDIUMTEXT</CODE>
</TR NOSAVE>
<TR><TD><CODE>MIDDLEINT</CODE> </TD><TD> <CODE>MEDIUMINT</CODE>
</TR NOSAVE>
<TR><TD><CODE>VARBINARY(NUM)</CODE> </TD><TD> <CODE>VARCHAR(NUM) BINARY</CODE>
</TR>
</TABLE>
-Starvation Prince-
|