Search Results
https://dev.mysql.com/doc/refman/26.7/en/information-schema-optimization.html
Consider this statement, which identifies collations for the utf8mb4 character set: mysql> SELECT COLLATION_NAME FROM INFORMATION_SCHEMA.COLLATION_CHARACTER_SET_APPLICABILITY WHERE CHARACTER_SET_NAME = 'utf8mb4'; +----------------------------+ | ...
https://dev.mysql.com/doc/refman/26.7/en/sql-mode.html
INTERPRET_UTF8_AS_UTF8MB4 Controls how the deprecated utf8 character set alias and utf8_* collation aliases are interpreted in SQL statements. The aliases utf8_general_mysql500_ci and utf8_tolower_ci are rejected when this mode is enabled because no ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/doc/refman/26.7/en/srjsapi-column.html
See Chapter 12, Character Sets, Collations, Unicode, for more information about MySQL character sets and collations. getCollationName() Retrieves the name of the character set collation used by the column. See Chapter 12, Character Sets, Collations, ... The Column object represents the column metadata in a result ...
https://dev.mysql.com/doc/relnotes/mysql-shell/26.7/en/news-8-0-32.html
(Bug #108426, Bug #34584939) The error ReplicaSet.status: Failed to execute query on Metadata Illegal mix of collations was returned if the server was configured with character-set-client-handshake=OFF or --skip-character-set-client-handshake, and ... Important This version includes a change which enables MySQL Shell to read MySQL Server option files and login paths by ...
https://dev.mysql.com/doc/relnotes/mysql-shell/26.7/en/news-9-5-0.html
Error similar to the following was returned: Requested MySQL version '9.3.1' is newer than the maximum version '9.3.0' supported by this version of MySQL Shell (ArgumentError) (Bug #38107377) Loading a dump using the collation utf8mb4_uca1400_ai_ci ... Note These release notes were created with the assistance of MySQL HeatWave ...
https://dev.mysql.com/doc/workbench/en/wb-using-table-tool.html
When the Tables pointer is active, this toolbar contains a schemas list, an engines list, a collations list, and a color chart list. Use these lists to select the appropriate schema, engine, collation, and color accent for the new table. The engine ... Tables can also be added to an EER Diagram using the table tool on the vertical ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-connection.html
Default Value CATALOG Since Version 8.0.17 detectCustomCollations Should the driver detect custom charsets/collations installed on server? If this option set to "true" the driver gets actual charsets/collations from the server each time a connection ... connectionAttributes A comma-delimited list of user-defined "key:value" pairs, in addition to standard MySQL-defined "key:value" pairs, to be passed to MySQL Server for display as connection attributes in the 'PERFORMANCE_SCHEMA' tables 'session_account_connect_attrs' and ...
https://dev.mysql.com/doc/internals/en/x-protocol-xplugin-implementation-of-the-x-protocol.html
Topics in this section: Mysqlx.Sql::StmtExecute Collations The X Plugin implements the X Protocol for the MySQL Server. Mysqlx.Sql::StmtExecute StmtExecute implements several namespaces: sql The SQL interface which expects: .stmt to be a string ...
https://dev.mysql.com/doc/relnotes/connector-python/en/news-8-0-30.html
(WL #14815) Added or renamed collations to align with MySQL Server 8.0.30. This includes adding support for language-specific utf8mb4 collations and renaming all existing utf8_ collations to utf8mb3_. Support for MySQL 5.7 collations is preserved ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-connection.html
Default Value CATALOG Since Version 8.0.17 detectCustomCollations Should the driver detect custom charsets/collations installed on server? If this option set to "true" the driver gets actual charsets/collations from the server each time a connection ... connectionAttributes A comma-delimited list of user-defined "key:value" pairs, in addition to standard MySQL-defined "key:value" pairs, to be passed to MySQL Server for display as connection attributes in the 'PERFORMANCE_SCHEMA' tables 'session_account_connect_attrs' and ...