Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-table-status.html
The output does not explicitly list the table default character set, but the collation name begins with the character set name. SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works like SHOW TABLES, but ...
https://dev.mysql.com/doc/refman/8.4/en/show-triggers.html
row *************************** Trigger: ins_sum Event: INSERT Table: account Statement: SET @sum = @sum + NEW.amount Timing: BEFORE Created: 2018-08-08 10:10:12.61 sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
(Bug #36049906) The strings and strings_shared library files declared but did not supply the function mysql::collation::find_by_id(). Condition pushdown to a view was rejected with a collation mismatch if the view was created with a different ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/adding-loadable-function.html
(xxx() is not even called for subsequent rows.) Loadable Function Character Set Handling By default, loadable functions take no account of the character set or collation of string arguments or return values. In MySQL 8.4 the interface for writing ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-4-0.html
(Bug #109339, Bug #34898663) Executing DatabaseMetadata.getColumns() with useInformationSchema=true and setting connectionCollation to anything other than utf8mb3_general_ci would cause a java.sql.SQLException for Illegal mix of collations. It was ... Note These release notes were created with the assistance of MySQL HeatWave ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-concepts.html
Index Yes Yes Yes Yes Information Schema Yes No Yes Yes Object Names Case Sensitivity Depends on collation Depends on collation Mixed Mixed MySQL: sensitivity of database, table, and trigger names OS dependent; other object names are not ... The ...
https://dev.mysql.com/doc/internals/en/event-data-for-specific-event-types.html
Value is three 2-byte unsigned integers representing the character_set_client, collation_connection, and collation_server system variables. Value is a 2-byte unsigned integer representing the collation_database system variable. The character set ...
https://dev.mysql.com/doc/internals/en/miscellaneous-options.html
For Autotools MySQL build options that have CMake equivalents, the normal mapping from an Autotools option to the CMake option is to convert uppercase, remove leading dashes, replace dashes with underscores, and add a leading -D.
https://dev.mysql.com/doc/internals/en/query-event.html
Note only written if code > 0 (aka "en_US") Q_CHARSET_DATABASE_CODE characterset and collation of the schema Q_TABLE_MAP_FOR_UPDATE_CODE a 64bit-field ... Binlog::QUERY_EVENT: The query event is used to send text querys right the binlog.
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords-5-7.html
This section provides information about keywords and reserved words in MySQL 5.7. MySQL 5.7 Keywords and Reserved Words MySQL 5.7 New Keywords and Reserved Words MySQL 5.7 Removed Keywords and Reserved Words MySQL 5.7 Keywords and Reserved Words ...