Search Results
https://dev.mysql.com/doc/refman/8.4/en/set.html
Note that SET 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. A SET is a string object that can have zero or more values, each of ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-database.html
row *************************** Database: test Create Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80014 DEFAULT ENCRYPTION='N' */ mysql> SHOW CREATE SCHEMA test\G ... SHOW CREATE {DATABASE ...
https://dev.mysql.com/doc/refman/8.4/en/system-schema.html
row *************************** CATALOG_NAME: def SCHEMA_NAME: mysql DEFAULT_CHARACTER_SET_NAME: utf8mb4 DEFAULT_COLLATION_NAME: utf8mb4_0900_ai_ci SQL_PATH: NULL DEFAULT_ENCRYPTION: NO *************************** 2. row *************************** ...It contains tables that store information required by the MySQL server as it ...
https://dev.mysql.com/doc/refman/8.4/en/type-conversion.html
Implicit conversion of a numeric or temporal value to string produces a value that has a character set and collation determined by the character_set_connection and collation_connection system variables. For information about connection character ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-prerequisites.html
Triggers must not have a missing or empty definer or an invalid creation context (indicated by the character_set_client, collation_connection, Database Collation attributes displayed by SHOW TRIGGERS or the INFORMATION_SCHEMA TRIGGERS table).
https://dev.mysql.com/doc/refman/8.4/en/user-variables.html
A value having the JSON data type is converted to a string with a character set of utf8mb4 and a collation of utf8mb4_bin. If a user variable is assigned a nonbinary (character) string value, it has the same character set and collation as the string. You can store a value in a user-defined variable in one statement and refer to it later in another ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/global-error-reference.html
This document lists “global” error messages that are shared in the sense that they can be produced by the MySQL server or by MySQL client programs. These errors have error codes in the range from 1 to 999. Each global error message includes an ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-get-character-set-info.html
Example This example shows the fields that are available in the MY_CHARSET_INFO structure: if (!mysql_set_character_set(&mysql, "utf8")) { MY_CHARSET_INFO cs; mysql_get_character_set_info(&mysql, &cs); printf("character set information:\n"); ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-list-fields.html
MYSQL_RES * mysql_list_fields(MYSQL *mysql, const char *table, const char *wild) Description Note mysql_list_fields() is deprecated and is subject to removal in a future version of MySQL. Instead, use mysql_real_query() or mysql_query() to execute ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-set-character-set.html
The connection collation becomes the default collation of the character set. int mysql_set_character_set(MYSQL *mysql, const char *csname) Description This function is used to set the default character set for the current connection. This function ...