데이터베이스/MYSQL

TINYBLOB, BLOB, MEDIUMBLOB and LONGBLOB 자료형

죠부니 2018. 11. 2. 11:25
반응형

TINYBLOB, BLOB, MEDIUMBLOB and LONGBLOB

A binary large object that can hold a variable amount of binary data. The sorting and comparison of the values for these objects is performed in case-sensitive manner.

TINYBLOB

A binary large object column with a maximum length of 255 (2^8 - 1) characters.

BLOB

A binary large object column with a maximum length of 65535 (2^16 - 1) characters.

MEDIUMBLOB

A binary large object column with a maximum length of 16777215 (2^24 - 1) characters.

LONGBLOB

A binary large object column with a maximum length of 4294967295 (2^32 - 1) characters.



https://doc.ispirer.com/sqlways/Output/SQLWays-1-201.html

반응형