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/charset-server.html
MySQL Server has a server character set and a server collation. By default, these are utf8mb4 and utf8mb4_0900_ai_ci, but they can be set explicitly at server startup on the command line or in an option file and changed at runtime. Initially, the ...If you don't specify a character set, that is the same as saying ...
https://dev.mysql.com/doc/refman/8.0/en/charset-syntax.html
Character set issues affect not only data storage, but also communication between client programs and the MySQL server. There are default settings for character sets and collations at four levels: server, database, table, and column. The ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf16.html
Because MySQL must allow for the worst case (that one character requires four bytes) the maximum length of a utf16 column or index is only half of the maximum length for a ucs2 column or index. The utf16 character set is the ucs2 character set with ...
https://dev.mysql.com/doc/refman/8.0/en/column-indexes.html
For queries that contain full-text expressions, MySQL evaluates those expressions during the optimization phase of query execution. The most common type of index involves a single column, storing copies of the values from that column in a data ...
https://dev.mysql.com/doc/refman/8.0/en/communication-errors.html
It takes more than connect_timeout seconds to obtain a connect packet. The cause can be any of the following: The client program did not call mysql_close() before exiting. The client had been sleeping more than wait_timeout or interactive_timeout ...
https://dev.mysql.com/doc/refman/8.0/en/compiler-characteristics.html
In some cases, the compiler used to build MySQL affects the features available for use. The notes in this section apply for binary distributions provided by Oracle Corporation or that you compile yourself from source. icc (Intel C++ Compiler) ...
https://dev.mysql.com/doc/refman/8.0/en/condition-handling-restrictions.html
In MySQL, this is not guaranteed, so to get the main error, you cannot do this: GET DIAGNOSTICS CONDITION 1 @errno = MYSQL_ERRNO; Instead, do this: GET DIAGNOSTICS @cno = NUMBER; GET DIAGNOSTICS CONDITION @cno @errno = MYSQL_ERRNO; . SIGNAL, ...
https://dev.mysql.com/doc/refman/8.0/en/condition-handling.html
For information about the diagnostics area, see Section 15.6.7.7, “The MySQL Diagnostics Area”. Conditions may arise during stored program execution that require special handling, such as exiting the current program block or continuing ...
https://dev.mysql.com/doc/refman/8.0/en/connection-management.html
This includes a description of the available connection interfaces, how the server uses connection handler threads, details about the administrative connection interface, and management of DNS lookups.
https://dev.mysql.com/doc/refman/8.0/en/controlling-optimizer.html
MySQL provides optimizer control through system variables that affect how query plans are evaluated, switchable optimizations, optimizer and index hints, and the optimizer cost model. The server maintains histogram statistics about column values in ...