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/extensions-to-ansi.html
String comparisons are case-insensitive by default, with sort ordering determined by the collation of the current character set, which is utf8mb4 by default. MySQL Server supports some extensions that you are not likely to find in other SQL DBMSs.
https://dev.mysql.com/doc/refman/8.0/en/faqs-mysql-cluster.html
This means that (for example) each Disk Data table record containing a VARCHAR(255) column requires space for 255 characters (as required for the character set and collation being used for the table), regardless of the actual number of characters ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-restrictions.html
Although the use of multiple character sets within a single table is supported, all columns in a FULLTEXT index must use the same character set and collation. Full-text searches are supported for InnoDB and MyISAM tables only. The exception is that ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
Used for storing text-based documents, with associated character set and collation order. These terms are commonly used in information about the MySQL database server. Files with this extension are always included in backups produced by the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-consistency-guarantees.html
Although the Transaction Synchronization Points section explains that conceptually there are two synchronization points from which you can choose: on read or on write, these terms were a simplification and the terms used in Group Replication are: ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-enterprise-backup.html
MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with MySQL Enterprise Edition. This section explains how to back up and subsequently restore a Group Replication member using MySQL Enterprise Backup. The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-character-sets-table.html
The CHARACTER_SETS table has these columns: CHARACTER_SET_NAME The character set name. MAXLEN The maximum number of bytes required to store one character. Notes Character set information is also available from the SHOW CHARACTER SET statement. The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-columns-table.html
For example, if you say SHOW FULL COLUMNS FROM t, and you see in the COLLATION_NAME column a value of utf8mb4_swedish_ci, the character set is what appears before the first underscore: utf8mb4. The related ST_GEOMETRY_COLUMNS table provides ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-events-table.html
COLLATION_CONNECTION The session value of the collation_connection system variable when the event was created. DATABASE_COLLATION The collation of the database with which the event is associated. The following statements are equivalent: SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-virtual-table.html
CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL, `c` int(11) GENERATED ALWAYS AS (5) VIRTUAL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; However, metadata for such a column does appear in the ... The ...