PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/option-defaults-equals.html
mysql> SELECT USER(); +---------------+ | USER() | +---------------+ | jon@localhost | +---------------+ 1 row in set (0.00 sec) This is not the same behavior as with the command line, where the equal sign is not required: $> mysql --user jon --host ...Consider the following example, where a user connects to a MySQL server running on host tonfisk as user jon: $> mysql --host 85.224.35.45 --user jon Welcome to the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/charset-mysql.html
To display the available character sets, use the INFORMATION_SCHEMA CHARACTER_SETS table or the SHOW CHARACTER SET statement. For more complete information, see Section 10.10, “Supported Character Sets and Collations”. To list the display ...| ...
https://dev.mysql.com/doc/refman/5.7/en/charset-repertoire.html
The ASCII range is a subset of UNICODE range, so a string with ASCII repertoire can be converted safely without loss of information to the character set of any string with UNICODE repertoire. The repertoire for function return values is determined ... The repertoire of a character set is the collection of characters in the ...String expressions have a repertoire attribute, which can have two values: ASCII: The expression can contain ...
https://dev.mysql.com/doc/refman/5.7/en/charset-errors.html
This section describes how the MySQL server uses character sets for constructing error messages. For information about the language of error messages (rather than the character set), see Section 10.12, “Setting the Error Message Language”. For ...Parameters in the message template are replaced with values that apply to a specific error occurrence: Identifiers such as table or column names use UTF-8 internally so they are copied as ...
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. utf8mb3 can be used in CHARACTER SET clauses, and ...Applications ...
https://dev.mysql.com/doc/refman/5.7/en/charset-table.html
The CREATE TABLE and ALTER TABLE statements have optional clauses for specifying the table character set and collation: CREATE TABLE tbl_name (column_list) [[DEFAULT] CHARACTER SET charset_name] [COLLATE collation_name]] ALTER TABLE tbl_name ...
https://dev.mysql.com/doc/refman/5.7/en/charset-server.html
If you specify only a character set (for example, latin1) but not a collation, that is the same as saying --character-set-server=latin1 --collation-server=latin1_swedish_ci because latin1_swedish_ci is the default collation for latin1. Therefore, ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation-unicode-uca.html
Table 10.4 MySQL Character Sets Available for User-Defined UCA Collations Character Set Base Collation utf8 utf8_unicode_ci ucs2 ucs2_unicode_ci utf16 utf16_unicode_ci utf32 utf32_unicode_ci The following sections show how to add a collation that is ...It is not possible to create user-defined UCA collations for utf16le; there is no utf16le_unicode_ci collation that would serve as the basis for such ... This section describes how to ...
https://dev.mysql.com/doc/refman/5.7/en/charset.html
MySQL includes character set support that enables you to store data using a variety of character sets and perform comparisons according to a variety of collations. The default MySQL server character set and collation are latin1 and ...Character set ...
https://dev.mysql.com/doc/refman/5.7/en/program-variables.html
See Section 13.7.4.1, “SET Syntax for Variable Assignment”, and Section 5.1.8, “Using System Variables”. To set the max_allowed_packet variable for mysql to a value of 16MB, use either of the following commands: mysql ... Many MySQL programs ...In MySQL 5.7, option prefixes are no longer supported; only full options are ...