BLOB TEXT MySQL.
BLOB , . , . , .
BLOB': TINYBLOB, BLOB, MEDIUMBLOB LONGBLOB, , .
TEXT: TINYTEXT, TEXT, MEDIUMTEXT LONGTEXT BLOB ( ). BLOB TEXT , BLOB TEXT.
BLOB TEXT , , , .
TEXT VARCHAR, , . BLOB VARCHAR BINARY. , :
- BLOB TEXT , , VARCHAR;
- BLOB TEXT ( DEFAULT).
BLOB TEXT , :
- GROUP BY ORDER BY BLOB TEXT, . : SUBSTRING, :
mysql> select comment from tbl_name, substring(comment, 20) as substr
ORDER BY substr;
, max_sort_length . max_sort_length 1024, - mysqld. , BLOB TEXT, :
mysql> select id,substring(blob_col,1,100) from tbl_name GROUP BY 2;
mysql> select id,substring(blob_col,1,100) as b from tbl_name GROUP BY b;
- BLOB TEXT , , , . , .