Search Results
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-17.html
(WL #13125) Added support for the utf8mb4_0900_bin collation, which is now supported by MySQL Server 8.0.17. Version 8.0.17 is the latest General Availability release of the 8.0 series of MySQL Connector/J. It is suitable for use with MySQL Server ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-2-0.html
(Bug #37143289) When evaluating an expression such as value BETWEEN 'a' AND 'b', the server now checks the string literals and ensures that they use the same character set and collation as the value to be compared with them. (Bug #37132323) This ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-6-0.html
(Bug #38170188, Bug #36782728, Bug #38549372) Under certain circumstances, when used for an upgrade, mysqlpump altered the SQL mode and collation of stored procedures. Note These release notes were created with the assistance of MySQL HeatWave ...
https://dev.mysql.com/doc/refman/26.7/en/ansi-diff-foreign-keys.html
For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does not permit the deletion of any of the parent rows. This means that you cannot use self-referential ON UPDATE CASCADE or ON UPDATE ...
https://dev.mysql.com/doc/refman/26.7/en/charset-conversion.html
Note ALTER TABLE statements which make changes in table or column character sets or collations must be performed using ALGORITHM=COPY. To convert a binary or nonbinary string column to use a particular character set, use ALTER TABLE. For successful ...
https://dev.mysql.com/doc/refman/26.7/en/charset-errors.html
For more information about character_set_results, see Section 12.4, “Connection Character Sets and Collations”. This section describes how the MySQL server uses character sets for constructing error messages. For information about the language ...
https://dev.mysql.com/doc/refman/26.7/en/charset-restrictions.html
In addition, these operators compare characters by their byte values and accented characters may not compare as equal even if a given collation treats them as equal. Identifiers are stored in mysql database tables (user, db, and so forth) using ...
https://dev.mysql.com/doc/refman/26.7/en/check-table.html
Changes are sometimes made to character sets or collations that require table indexes to be rebuilt. option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for errors. CHECK TABLE can also check ...
https://dev.mysql.com/doc/refman/26.7/en/create-table-check-constraints.html
CREATE TABLE permits the core features of table and column CHECK constraints, for all storage engines. CREATE TABLE permits the following CHECK constraint syntax, for both table constraints and column constraints: [CONSTRAINT [symbol]] CHECK (expr) ...
https://dev.mysql.com/doc/refman/26.7/en/create-table-select.html
Retrained attributes are NULL (or NOT NULL) and, for those columns that have them, CHARACTER SET, COLLATION, COMMENT, and the DEFAULT clause. You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE ...