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-charsets.html
There is one subsection for each group of related character sets. To list the available character sets and their default collations, use the SHOW CHARACTER SET statement or query the INFORMATION_SCHEMA CHARACTER_SETS table. To avoid choosing the ...
https://dev.mysql.com/doc/refman/5.7/en/error-message-language.html
For information about changing the character set for error messages (rather than the language), see Section 10.6, “Error Message Character Set”. For example, if the server is using the fr_FR locale for error messages, a client can execute this ...For general information about configuring error logging, see Section 5.4.2, “The Error ... By default, mysqld produces error messages in English, but they can be displayed instead in any of several other languages: Czech, Danish, Dutch, Estonian, French, German, Greek, Hungarian, Italian, Japanese, ...
https://dev.mysql.com/doc/refman/5.7/en/sys-sys-config-insert-set-user.html
For rows added to the sys_config table by INSERT statements, the sys_config_insert_set_user trigger sets the set_by column to the current user.
https://dev.mysql.com/doc/refman/5.7/en/information-schema-character-sets-table.html
Notes Character set information is also available from the SHOW CHARACTER SET statement. The following statements are equivalent: SELECT * FROM INFORMATION_SCHEMA.CHARACTER_SETS [WHERE CHARACTER_SET_NAME LIKE 'wild'] SHOW CHARACTER SET [LIKE 'wild'] ...The CHARACTER_SETS table has these columns: CHARACTER_SET_NAME The character set ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf16.html
The utf16 character set is the ucs2 character set with an extension that enables encoding of supplementary characters: For a BMP character, utf16 and ucs2 have identical storage characteristics: same code values, same encoding, same length. For a ...Consequently, all supplementary characters require 32 bits, where the first 16 bits are a number between 0xd800 and 0xdbff, and the last 16 bits are a number between 0xdc00 and ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-enum.html
For a column defined as SET('a','b','c'), values such as 'd' or 'a,b,c,d' are invalid and are rejected. For SET, the value is inserted as given except that any invalid substrings are deleted. ENUM and SET columns provide an efficient way to define ...The value cannot be the error value (that is, 0 or the empty ...
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-national.html
For example, these data type declarations are equivalent: CHAR(10) CHARACTER SET utf8 NATIONAL CHARACTER(10) NCHAR(10) As are these: VARCHAR(10) CHARACTER SET utf8 NATIONAL VARCHAR(10) NVARCHAR(10) NCHAR VARCHAR(10) NATIONAL CHARACTER VARYING(10) ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-charset.html
The following applies to replication between MySQL servers that use different character sets: If the source has databases with a character set different from the global character_set_server value, you should design your CREATE TABLE statements so ...A good workaround is to state the character set and collation explicitly in CREATE TABLE ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-connection-tables.html
It removes rows for accounts, hosts, or users with no connections, and resets the summary columns to zero for the remaining rows. The Performance Schema also counts internal threads and threads for user sessions that failed to authenticate, using ...