PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset-column.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” column (that is, a column of type CHAR, VARCHAR, a TEXT type, or any synonym) has ...
https://dev.mysql.com/doc/refman/5.7/en/charset-database.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 database has a database character set and a database collation. The CREATE DATABASE and ALTER ...
https://dev.mysql.com/doc/refman/5.7/en/charset-examples.html
The following examples show how MySQL determines default character set and collation values. Example 1: Table and Column Definition CREATE TABLE t1 ( c1 CHAR(10) CHARACTER SET latin1 COLLATE latin1_german1_ci ) DEFAULT CHARACTER SET latin2 COLLATE ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/charset-table.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 table has a table character set and a table collation. The CREATE TABLE and ALTER TABLE statements ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-sets.html
A language name shown in the following table indicates a language-specific collation. This section describes the collations available for Unicode character sets and their differentiating properties. MySQL supports multiple Unicode character sets: ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf32.html
The utf32 character set is fixed length (like ucs2 and unlike utf16). utf32 uses 32 bits for every character, unlike ucs2 (which uses 16 bits for every character), and unlike utf16 (which uses 16 bits for some characters and 32 bits for others).
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf8mb3.html
The utf8mb3 character set has these characteristics: Supports BMP characters only (no support for supplementary characters) Requires a maximum of three bytes per multibyte character. Applications that use UTF-8 data but require supplementary ...
https://dev.mysql.com/doc/refman/5.7/en/check-table.html
CHECK TABLE Output Checking Version Compatibility Checking Data Consistency CHECK TABLE Usage Notes for InnoDB Tables CHECK TABLE Usage Notes for MyISAM Tables CHECK TABLE Output CHECK TABLE returns a result set with the columns shown in the ...
https://dev.mysql.com/doc/refman/5.7/en/cleartext-pluggable-authentication.html
The mysql, mysqladmin, and mysqlslap client programs (also mysqlcheck, mysqldump, and mysqlshow for MySQL 5.7.10 and later) support an --enable-cleartext-plugin option that enables the plugin on a per-invocation basis. A client-side authentication ...