If strict SQL mode is not enabled, a VARCHAR column with a length specification greater than 65535 is converted to TEXT, and a VARBINARY column with a length specification greater than 65535 is converted to BLOB. Specifying the CHARACTER SET binary ... In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE ...

It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT). Static-format tables have these characteristics: CHAR and VARCHAR columns are space-padded to the specified column width, although the column type is ...Of the three MyISAM storage formats, static format is the simplest and most secure (least subject to ...

Triggers are similar to stored functions, so the preceding remarks regarding functions also apply to triggers with the following exception: CREATE TRIGGER does not have an optional DETERMINISTIC characteristic, so triggers are assumed to be always ... The binary log contains information about SQL statements that modify database ...

expr LIKE pat [ESCAPE 'escape_char'] Pattern matching using an SQL pattern. This differs from comparisons performed with the = operator, for which the significance of trailing spaces in nonbinary strings (CHAR, VARCHAR, and TEXT values) depends on ... Table 14.13 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching STRCMP() Compare two strings If a string function is given a binary string as an argument, the resulting string is also a binary ...

The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For information about storage requirements of the string data types, see Section 13.7, “Data Type Storage Requirements”. For descriptions of functions that ...