Search Results
https://dev.mysql.com/doc/connectors/en/connector-python-connectargs.html
collation utf8mb4_general_ai_ci (is utf8_general_ci in 2.x Which MySQL collation to use. Similar to the charset property, you can set the collation for the current MySQL session. A connection with the MySQL server can be established using either ...
https://dev.mysql.com/doc/connector-python/en/connector-python-connectargs.html
collation utf8mb4_general_ai_ci (is utf8_general_ci in 2.x Which MySQL collation to use. Similar to the charset property, you can set the collation for the current MySQL session. A connection with the MySQL server can be established using either ...
https://dev.mysql.com/doc/internals/en/x-protocol-messages-messages.html
message Scalar { // a string with a charset/collation message String { required bytes value = 1; optional uint64 collation = 2; }; // an opaque octet sequence, with an optional content_type // See ``Mysqlx.Resultset.ColumnMetadata`` for list of ...
https://dev.mysql.com/doc/heatwave/en/heatwave-errors.html
The following list contains all current MySQL HeatWave errors in numerical order. The entry for each error contains the error number, name (symbol), description, and suggested workaround for the condition that gave rise to the error. Error number: ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-4-0.html
(Bug #109339, Bug #34898663) Executing DatabaseMetadata.getColumns() with useInformationSchema=true and setting connectionCollation to anything other than utf8mb3_general_ci would cause a java.sql.SQLException for Illegal mix of collations. It was ... Note These release notes were created with the assistance of MySQL HeatWave ...
https://dev.mysql.com/doc/refman/9.7/en/alter-table-examples.html
row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1 row in set (0.01 sec) To change ...For NDB tables, it is also possible to change the storage type used for a table or ...
https://dev.mysql.com/doc/refman/9.7/en/analyze-table.html
row *************************** SCHEMA_NAME: h TABLE_NAME: t COLUMN_NAME: c1 HISTOGRAM: {"buckets": [], "data-type": "int", "auto-update": false, "null-values": 0.0, "collation-id": 8, "last-updated": "2024-03-26 16:54:43.674995", "sampling-rate": ...ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ...
https://dev.mysql.com/doc/refman/9.7/en/blob.html
They have the binary character set and collation, and comparison and sorting are based on the numeric values of the bytes in column values. They have a character set other than binary, and values are sorted and compared based on the collation of the ... A BLOB is a binary large object that can hold a variable amount of ...
https://dev.mysql.com/doc/refman/9.7/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/9.7/en/charset-metadata.html
(See Section 12.4, “Connection Character Sets and Collations”.) Alternatively, a client program can perform the conversion after receiving the result from the server. Because it is a well-known principle that “what applies to a superset can ...