PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.4Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html
If the expression contains any polygons with inner rings, an ER_WRONG_PARAMETERS_TO_STORED_FCT error occurs. Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string 8.0.27 CAST() Cast a value as ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-coercibility.html
The collation of a column or a stored routine parameter or local variable has a coercibility of 2. In the great majority of statements, it is obvious what collation MySQL uses to resolve a comparison operation. For example, in the following cases, ...
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/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/8.0/en/charset-general.html
MySQL can do these things for you: Store strings using a variety of character sets. A character set is a set of symbols and encodings. A collation is a set of rules for comparing characters in a character set. Let's make the distinction clear with ...
https://dev.mysql.com/doc/refman/8.0/en/charset-metadata.html
To satisfy both requirements, MySQL stores metadata in a Unicode character set, namely UTF-8. Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is metadata. Thus ...
https://dev.mysql.com/doc/refman/8.0/en/charset-restrictions.html
Identifiers are stored in mysql database tables (user, db, and so forth) using utf8mb3, but identifiers can contain only characters in the Basic Multilingual Plane (BMP). The ucs2, utf16, utf16le, and utf32 character sets have the following ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf32.html
Also, unlike utf16, there are no tricks for encoding in utf32, so the stored value equals the code value. 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 ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode.html
The MySQL implementation of UCS-2, UTF-16, and UTF-32 stores characters in big-endian byte order and does not use a byte order mark (BOM) at the beginning of values. The Unicode Standard includes characters from the Basic Multilingual Plane (BMP) ...
https://dev.mysql.com/doc/refman/8.0/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 utf8mb4 and ...