Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-table-ndb-comment-options.html
It does not indicate the number of characters, which varies according to the character set and collation used by the column. NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-object-cache.html
collation definition cache partition: Stores collation definition objects and has a hardcoded object limit of 256. The dictionary object cache is a shared global cache that stores previously accessed data dictionary objects in memory to enable ...
https://dev.mysql.com/doc/refman/8.4/en/docker-mysql-more-topics.html
For example: docker run --name mysql1 -d container-registry.oracle.com/mysql/community-server:tag --character-set-server=utf8mb4 --collation-server=utf8mb4_col The command starts the MySQL Server with utf8mb4 as the default character set and ...A ...
https://dev.mysql.com/doc/refman/8.4/en/encryption-functions.html
Their return value is a string that has a character set and collation determined by the character_set_connection and collation_connection system variables. Storing the string also results in slower comparisons because of the larger values and the ...
https://dev.mysql.com/doc/refman/8.4/en/enum.html
Note that ENUM columns can be assigned a character set and collation. For binary or case-sensitive collations, lettercase is taken into account when assigning values to the column. An ENUM is a string object with a value chosen from a list of ...
https://dev.mysql.com/doc/refman/8.4/en/features.html
Sorting and comparisons are done according to the default character set and collation. It is possible to change this when the MySQL server is started (see Section 12.3.2, “Server Character Set and Collation”). This section describes some of the ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-natural-language.html
To perform a case-sensitive full-text search, use a case-sensitive or binary collation for the indexed columns. For example, a column that uses the utf8mb4 character set of can be assigned a collation of utf8mb4_0900_as_cs or utf8mb4_bin to make it ... By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string against a text ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-case-sensitivity.html
Object names may be considered duplicates if their uppercase forms are equal according to a binary collation. For more information, see Section 12.8.7, “Using Collation in INFORMATION_SCHEMA Searches”. In MySQL, databases correspond to ...
https://dev.mysql.com/doc/refman/8.4/en/import-table.html
Any collation IDs stored in the .sdi file must refer to the same collations on the export and import servers. The IMPORT TABLE statement imports MyISAM tables based on information contained in .sdi (serialized dictionary information) metadata files.
https://dev.mysql.com/doc/refman/8.4/en/index-page-merge-threshold.html
row *************************** Table: t2 Create Table: CREATE TABLE `t2` ( `id` int(11) DEFAULT NULL, KEY `id_index` (`id`) COMMENT 'MERGE_THRESHOLD=40' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci Note A MERGE_THRESHOLD value ...If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to merge the index page with a neighboring index ...