PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/character-arrays.html
Each simple character set has a configuration file located in the sql/share/charsets directory. For a character set named MYSYS, the file is named MYSET.xml. <map> elements appear within these elements: <ctype> defines attributes for each character. <collation> elements indicate character ordering for comparison and sorting, one element per ...
https://dev.mysql.com/doc/refman/8.0/en/cannot-initialize-character-set.html
You might see an error like this if you have character set problems: MySQL Connection Failed: Can't initialize character set charset_name This error can have any of the following causes: The character set is a multibyte character set and you have ...In this case, you need to recompile the client by running CMake with the -DDEFAULT_CHARSET=charset_name ...
https://dev.mysql.com/doc/refman/8.0/en/show-character-set.html
SHOW {CHARACTER SET | CHARSET} [LIKE 'pattern' | WHERE expr] The SHOW CHARACTER SET statement shows all available character sets. The LIKE clause, if present, indicates which character set names to match. Maxlen The maximum number of bytes required ...The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/set-character-set.html
SET {CHARACTER SET | CHARSET} {'charset_name' | DEFAULT} This statement maps all strings sent between the server and the current client with the given mapping. SET CHARACTER SET sets three session system variables: character_set_client and ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-character.html
For character and string columns, follow these guidelines: Use binary collation order for fast comparison and sort operations, when you do not need language-specific collation features. When comparing values from different columns, declare those ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
Some options, which you might not use initially, help tune InnoDB performance characteristics based on machine capacity and your database workload. For the characteristics of each lock mode, see InnoDB AUTO_INCREMENT Lock Modes. For best efficiency, ... InnoDB Startup Options InnoDB System Variables System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
Internationalization Options The following options change how the mysqldump command represents character data with national language settings. These may be used when dumping stored programs to preserve their character encodings. Note A dump made ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html
This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character sets. Note This discussion focuses primarily on converting between utf8mb3 and utf8mb4, but similar principles apply to ...One ...
https://dev.mysql.com/doc/refman/8.0/en/charset-cp932.html
Why is cp932 needed? In MySQL, the sjis character set corresponds to the Shift_JIS character set defined by IANA, which supports JIS X0201 and JIS X0208 characters. (See http://www.iana.org/assignments/character-sets.) However, the meaning of ...
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 ...