PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/caching-sha2-pluggable-authentication.html
To enable this capability, enable both required system variables, check_proxy_users and caching_sha2_password_proxy_users: SET GLOBAL check_proxy_users = ON; SET GLOBAL caching_sha2_password_proxy_users = ON; For information on PROXY and proxied ...
https://dev.mysql.com/doc/refman/9.7/en/can-not-connect-to-server.html
This is because Internet routing can cause a packet to take a slow route to its destination and it may arrive after both sides have agreed to close. A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix ...
https://dev.mysql.com/doc/refman/9.7/en/case-sensitivity.html
For nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands. For binary strings (BINARY, VARBINARY, BLOB), comparisons use the numeric values of the bytes in the operands; this means that for alphabetic ...
https://dev.mysql.com/doc/refman/9.7/en/cast-functions.html
Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string Yes CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values ...
https://dev.mysql.com/doc/refman/9.7/en/charset-collation-implementations.html
(For example, the single-byte characters 'a' and 'A' both have a weight of 0x41.) For multibyte characters, there are two types of relationship between character codes and weights: Weights equal character codes. MySQL implements several types of ...
https://dev.mysql.com/doc/refman/9.7/en/charset-collation-information-schema.html
String columns in INFORMATION_SCHEMA tables have a collation of utf8mb3_general_ci, which is case-insensitive. However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in ...
https://dev.mysql.com/doc/refman/9.7/en/charset-column.html
Every “character” column (that is, a column of type CHAR, VARCHAR, a TEXT type, or any synonym) has a column character set and a column collation. CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ) CHARACTER SET ...
https://dev.mysql.com/doc/refman/9.7/en/charset-compatibility.html
For MaxDB compatibility these two statements are the same: CREATE TABLE t1 (f1 CHAR(N) UNICODE); CREATE TABLE t1 (f1 CHAR(N) CHARACTER SET ucs2); Both the UNICODE attribute and the ucs2 character set are deprecated; you should expect them to be ...
https://dev.mysql.com/doc/refman/9.7/en/charset-configuration.html
However, when character_set_system differs from character_set_server or character_set_client, and you input characters manually (as database object identifiers, column values, or both), these may be displayed incorrectly in output from the client or ... The MySQL server has a compiled-in default character set and ...
https://dev.mysql.com/doc/refman/9.7/en/charset-connection.html
Conversion may be lossy for characters that are not in both character sets. A “connection” is what a client program makes when it connects to the server, to begin a session within which it interacts with the server. The client sends SQL ...