Search Results
https://dev.mysql.com/doc/refman/8.4/en/cannot-roll-back.html
In general, these include data definition language (DDL) statements, such as those that create or drop databases, those that create, drop, or alter tables or stored routines. If you issue a statement early in a transaction that cannot be rolled ...
https://dev.mysql.com/doc/refman/8.4/en/case-sensitivity.html
For nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands. For binary strings (BINARY, VARBINARY, BLOB), comparisons use the numeric values of the bytes in the operands; this means that for alphabetic ...
https://dev.mysql.com/doc/refman/8.4/en/channels-naming-conventions.html
Because channel names are used in the replica's applier metadata repository table, the character set used for these is always UTF-8. This section describes how naming conventions are impacted by replication channels. Each replication channel has a ...
https://dev.mysql.com/doc/refman/8.4/en/charset-charsets.html
To list the available character sets and their default collations, use the SHOW CHARACTER SET statement or query the INFORMATION_SCHEMA CHARACTER_SETS table. There is one subsection for each group of related character sets. To avoid choosing the ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-coercibility.html
In the great majority of statements, it is obvious what collation MySQL uses to resolve a comparison operation. For example, in the following cases, it should be clear that the collation is the collation of column x: SELECT x FROM T ORDER BY x; ...
https://dev.mysql.com/doc/refman/8.4/en/charset-configuration.html
To determine which collations are available for each character set, use the SHOW COLLATION statement or query the INFORMATION_SCHEMA COLLATIONS table. The MySQL server has a compiled-in default character set and collation. To change these defaults, ...
https://dev.mysql.com/doc/refman/8.4/en/charset-errors.html
Parameters in the message template are replaced with values that apply to a specific error occurrence: Identifiers such as table or column names use UTF-8 internally so they are copied as is. This section describes how the MySQL server uses ...
https://dev.mysql.com/doc/refman/8.4/en/charset-general.html
Mix strings with different character sets or collations in the same server, the same database, or even the same table. A character set is a set of symbols and encodings. A collation is a set of rules for comparing characters in a character set.
https://dev.mysql.com/doc/refman/8.4/en/charset-introducer.html
To see the default collation for each character set, use the SHOW CHARACTER SET statement or query the INFORMATION_SCHEMA CHARACTER_SETS table. A character string literal, hexadecimal literal, or bit-value literal may have an optional character set ...
https://dev.mysql.com/doc/refman/8.4/en/charset-literal.html
To see the default collation for each character set, use the SHOW CHARACTER SET statement or query the INFORMATION_SCHEMA CHARACTER_SETS table. Every character string literal has a character set and a collation. For the simple statement SELECT ...