본문 바로가기
데이터베이스/MYSQL

TINYBLOB, BLOB, MEDIUMBLOB and LONGBLOB 자료형

by 죠부니 2018. 11. 2.
반응형

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

반응형

'데이터베이스 > MYSQL' 카테고리의 다른 글

DELETE LEFT JOIN  (0) 2020.02.18
시구동 관련 법정동 자료  (0) 2020.01.17
ROWNUM  (0) 2020.01.13
lastInsertId  (0) 2019.08.14
MYSQL 자주사용하는 명령어  (0) 2018.07.08