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-column.html
If you use ALTER TABLE to convert a column from one character set to another, MySQL attempts to map the data values, but if the character sets are incompatible, there may be data loss. Every “character” column (that is, a column of type CHAR, ...
https://dev.mysql.com/doc/refman/8.0/en/charset-gb18030.html
In MySQL, the gb18030 character set corresponds to the “Chinese National Standard GB 18030-2005: Information technology — Chinese coded character set”, which is the official character set of the People's Republic of China (PRC). Unassigned ...
https://dev.mysql.com/doc/refman/8.0/en/charset-national.html
These statements are equivalent: SELECT N'some text'; SELECT n'some text'; SELECT _utf8'some text'; MySQL 8.0 interprets the national character set as utf8mb3, which is now deprecated. Standard SQL defines NCHAR or NATIONAL CHAR as a way to ...
https://dev.mysql.com/doc/refman/8.0/en/charset-table.html
) CHARACTER SET latin1 COLLATE latin1_danish_ci; MySQL chooses the table character set and collation in the following manner: If both CHARACTER SET charset_name and COLLATE collation_name are specified, character set charset_name and collation ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html
For the CHAR, VARCHAR, and TEXT data types, watch for these issues when converting your MySQL tables: Check all definitions of utf8mb3 columns and make sure they do not exceed the maximum length for the storage engine. If you have converted to ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-ucs2.html
Note The ucs2 character set is deprecated in MySQL 8.0.28; expect it to be removed in a future MySQL release. In UCS-2, every character is represented by a 2-byte Unicode code with the most significant byte first. For example: LATIN CAPITAL LETTER ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-encrypted-data.html
When cloning data to a local data directory that uses a locally managed keyring, the same keyring must be used when starting the MySQL server on the clone directory. When cloning data to a remote data directory (the recipient directory) that uses a ...The following requirements apply: A secure connection is required when cloning remote data to ensure safe transfer of unencrypted tablespace keys over the ...
https://dev.mysql.com/doc/refman/8.0/en/connection-control-plugin.html
MySQL Server includes a plugin library that enables administrators to introduce an increasing delay in server response to connection attempts after a configurable number of consecutive failed attempts. This capability provides a deterrent that ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-invalid-data.html
By default, MySQL 8.0 rejects invalid or improper data values and aborts the statement in which they occur. Older versions of MySQL employed the forgiving behavior by default; for a description of this behavior, see Constraints on Invalid Data. It ...
https://dev.mysql.com/doc/refman/8.0/en/cursor-restrictions.html
Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() function. In MySQL, a server-side cursor is materialized into an internal temporary table. A server-side cursor enables a result set to be generated on the server ...