PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/charset-national.html
Thus, using NATIONAL CHARACTER or one of its synonyms to define the character set for a database, table, or column raises a warning similar to this one: NATIONAL/NCHAR/NVARCHAR implies the character set UTF8MB3, which will be replaced by UTF8MB4 in ... Standard SQL defines NCHAR or NATIONAL CHAR as a way to indicate that a CHAR column should use some predefined character ...
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-syntax.html
There are default settings for character sets and collations at four levels: server, database, table, and column. The description in the following sections may appear complex, but it has been found in practice that multiple-level defaulting leads ...
https://dev.mysql.com/doc/refman/8.0/en/charset-table.html
Otherwise (neither CHARACTER SET nor COLLATE is specified), the database character set and collation are used. Every table has a table character set and a table collation. The CREATE TABLE and ALTER TABLE statements have optional clauses for ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode.html
Other database systems might use little-endian byte order or a BOM. The Unicode Standard includes characters from the Basic Multilingual Plane (BMP) and supplementary characters that lie outside the BMP. For information about the Unicode Standard ...
https://dev.mysql.com/doc/refman/8.0/en/charset.html
The default MySQL server character set and collation are utf8mb4 and utf8mb4_0900_ai_ci, but you can specify character sets at the server, database, table, column, and string literal levels. MySQL includes character set support that enables you to ...
https://dev.mysql.com/doc/refman/8.0/en/communication-errors.html
Unsuccessful connection attempts can occur for the following reasons: A client attempts to access a database but has no privileges for it. If connection problems occur such as communication errors or aborted connections, use these sources of ...
https://dev.mysql.com/doc/refman/8.0/en/concurrent-inserts.html
However, this cannot be used if you are going to manipulate the database using processes external to the server while you hold the lock. If there are multiple INSERT statements, they are queued and performed in sequence, concurrently with the SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/connection-access.html
In particular, do not give nonadministrative users read access to tables in the mysql system database. When you attempt to connect to a MySQL server, the server accepts or rejects the connection based on these conditions: Your identity and whether ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-foreign-key.html
Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data consistent. MySQL supports ON UPDATE and ON DELETE foreign key references in CREATE TABLE and ALTER TABLE statements. The ...