https://dev.mysql.com/mysql-fetch-field.html
If you've called mysql_query() to perform a SELECT on a table but have not called mysql_store_result(), MySQL returns the default blob length (8KB) if you call mysql_fetch_field() to ask for the length of a BLOB field. (The 8KB size is chosen ...
https://dev.mysql.com/mysqldump.html
--hex-blob Dump binary columns using hexadecimal notation (for example, 'abc' becomes 0x616263). The affected data types are BINARY, VARBINARY, BLOB types, BIT, all spatial data types, and other non-binary data types when used with the binary ...
https://dev.mysql.com/mysqlpump.html
--hex-blob Dump binary columns using hexadecimal notation (for example, 'abc' becomes 0x616263). The affected data types are BINARY, VARBINARY, BLOB types, BIT, all spatial data types, and other non-binary data types when used with the binary ...
https://dev.mysql.com/replication-features-differing-tables.html
Between any of the binary data types BINARY, VARBINARY, and BLOB, including conversions between different widths. Conversion of a BINARY, VARBINARY, or BLOB to a BINARY, VARBINARY, or BLOB column the same size or larger is never lossy. Source and ...
https://dev.mysql.com/silent-column-changes.html
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 ...
https://dev.mysql.com/archive-storage-engine.html
It does support ORDER BY operations, BLOB columns, and spatial data types (see Section 11.5.1, “Spatial Data Types”). The ARCHIVE engine ignores BLOB columns if they are not requested and scans past them while reading. The ARCHIVE storage ...
https://dev.mysql.com/bit-functions.html
In MySQL 8.0, bit functions and operators permit binary string type arguments (BINARY, VARBINARY, and the BLOB types) and return a value of like type, which enables them to take arguments and produce return values larger than 64 bits. (For examples, ...(The BIT_AND(), BIT_OR(), and BIT_XOR() aggregate functions are described in Section 12.20.1, “Aggregate (GROUP BY) Function Descriptions”.) Prior to MySQL 8.0, bit functions and operators required BIGINT (64-bit integer) arguments and returned BIGINT values, so they had a maximum range of 64 ...
https://dev.mysql.com/c-api-prepared-statement-type-codes.html
For input string data, use MYSQL_TYPE_STRING or MYSQL_TYPE_BLOB depending on whether the value is a character (nonbinary) or binary string: MYSQL_TYPE_STRING indicates character input string data. The buffer_type member of MYSQL_BIND structures ...
https://dev.mysql.com/cast-functions.html
For example, if the conversion result character set has a case-insensitive collation, a LIKE operation is not case-sensitive: SELECT 'A' LIKE CONVERT(blob_col USING latin1) FROM tbl_name; To use a different character set, substitute its name for ...
https://dev.mysql.com/charset-conversion.html
For successful conversion to occur, one of the following conditions must apply: If the column has a binary data type (BINARY, VARBINARY, BLOB), all the values that it contains must be encoded using a single character set (the character set you're ...
