PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/binary-varbinary.html
This means they have the binary character set and collation, and comparison and sorting are based on the numeric values of the bytes in the values. The BINARY and VARBINARY types are similar to CHAR and VARCHAR, except that they store binary ...
https://dev.mysql.com/doc/refman/8.0/en/blob.html
They have the binary character set and collation, and comparison and sorting are based on the numeric values of the bytes in column values. A BLOB is a binary large object that can hold a variable amount of data. These differ only in the maximum ...
https://dev.mysql.com/doc/refman/8.0/en/case-sensitivity.html
For binary strings (BINARY, VARBINARY, BLOB), comparisons use the numeric values of the bytes in the operands; this means that for alphabetic characters, comparisons are case-sensitive. For nonbinary strings (CHAR, VARCHAR, TEXT), string searches ...
https://dev.mysql.com/doc/refman/8.0/en/character-arrays.html
Each simple character set has a configuration file located in the sql/share/charsets directory. For a character set named MYSYS, the file is named MYSET.xml. <map> elements appear within these elements: <ctype> defines attributes for each character. <collation> elements indicate character ordering for comparison and sorting, one element per ...
https://dev.mysql.com/doc/refman/8.0/en/choosing-types.html
For optimum storage, you should try to use the most precise type in all cases. For example, if an integer column is used for values in the range from 1 to 99999, MEDIUMINT UNSIGNED is the best type. Of the types that represent all the required ...
https://dev.mysql.com/doc/refman/8.0/en/command-line-options.html
(This is also true for system variables set within option files.) For options that take a numeric value, the value can be given with a suffix of K, M, or G to indicate a multiplier of 1024, 10242 or 10243. Program options specified on the command ...
https://dev.mysql.com/doc/refman/8.0/en/connecting-using-uri-or-key-value-pairs.html
You can specify them to select the compression algorithm used for the connection, and the numeric compression level used with that algorithm. This section describes use of URI-like connection strings or key-value pairs to specify how to establish ...
https://dev.mysql.com/doc/refman/8.0/en/connection-options.html
--port=port_num, -P port_num Command-Line Format --port=port_num Type Numeric Default Value 3306 For TCP/IP connections, the port number to use. --ssl-fips-mode={OFF|ON|STRICT} Command-Line Format --ssl-fips-mode={OFF|ON|STRICT} Deprecated 8.0.34 ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-enum.html
An error occurs for values that do not satisfy these conditions: An ENUM value must be one of those listed in the column definition, or the internal numeric equivalent thereof. ENUM and SET columns provide an efficient way to define columns that ...
https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html
Implicit defaults are defined as follows: For numeric types, the default is 0, with the exception that for integer or floating-point types declared with the AUTO_INCREMENT attribute, the default is the next value in the sequence. Data type ...