. .

    @Mail.ru -

BLOB TEXT MySQL.

» PHP » MySQL » BLOB TEXT

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 , , , . , .