PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/charset-introducer.html
A character string literal, hexadecimal literal, or bit-value literal may have an optional character set introducer and COLLATE clause, to designate it as a string that uses a particular character set and collation: [_charset_name] literal [COLLATE ...It does not change the string value, although padding may ...
https://dev.mysql.com/doc/refman/8.0/en/charset-database.html
Every database has a database character set and a database collation. The CREATE DATABASE and ALTER DATABASE statements have optional clauses for specifying the database character set and collation: CREATE DATABASE db_name [[DEFAULT] CHARACTER SET ...Database options are stored in the data dictionary and can be examined by checking the Information Schema SCHEMATA ...
https://dev.mysql.com/doc/refman/8.0/en/charset-conversion.html
To convert a binary or nonbinary string column to use a particular character set, use ALTER TABLE. For successful conversion to occur, one of the following conditions must apply: If the column has a binary data type (BINARY, VARBINARY, BLOB), all ...Suppose that a table t has a binary column named col1 defined as ...
https://dev.mysql.com/doc/refman/8.0/en/charset-configuration.html
The MySQL server has a compiled-in default character set and collation. To change these defaults, use the --character-set-server and --collation-server options when you start the server. The collation must be a legal collation for the default ...
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
However, by default, no whitespace is permitted in function invocations between the function name and the following ( character. Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
(Exception: Element 1 cannot be empty or missing.) In all cases, an element may be surrounded by whitespace characters and the entire list is enclosed in single quotes. For more information about SSL file autogeneration, including file names and ...
https://dev.mysql.com/doc/refman/8.0/en/load-data.html
Input File Character Set The file name must be given as a literal string. The server interprets the file name using the character set indicated by the character_set_filesystem system variable. By default, the server interprets the file contents ...
https://dev.mysql.com/doc/refman/8.0/en/charset-repertoire.html
The repertoire of a character set is the collection of characters in the set. String expressions have a repertoire attribute, which can have two values: ASCII: The expression can contain only ASCII characters; that is, characters in the Unicode ...
https://dev.mysql.com/doc/refman/8.0/en/regexp.html
This section discusses the functions and operators available for regular expression matching and illustrates, with examples, some of the special characters and constructs that can be used for regular expression operations. MySQL implements regular ...(Prior to MySQL 8.0.4, MySQL used Henry Spencer's implementation of regular expressions, which operates in byte-wise fashion and is not multibyte ...
https://dev.mysql.com/doc/refman/8.0/en/charset-mysql.html
MySQL Server supports multiple character sets, including several Unicode character sets. To display the available character sets, use the INFORMATION_SCHEMA CHARACTER_SETS table or the SHOW CHARACTER SET statement. For more complete information, ...