Rechercher dans le manuel MySQL
Search Results
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 ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-blob-p-4.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
