Search Results
https://dev.mysql.com/doc/refman/9.7/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. You can use the BINARY operator to use binary collation within ...For column values less than 8KB in size, use binary VARCHAR instead of ...
https://dev.mysql.com/doc/refman/9.7/en/optimizer-statistics.html
Here is a sample histogram object: { "buckets": [ [ 1, 0.3333333333333333 ], [ 2, 0.6666666666666666 ], [ 3, 1 ] ], "null-values": 0, "last-updated": "2017-03-24 13:32:40.000000", "sampling-rate": 1, "histogram-type": "singleton", ... The ...
https://dev.mysql.com/doc/refman/9.7/en/prepare.html
If all operands of the operator are parameters, the derived type is VARCHAR; its collation is determined by the value of collation_connection. If all operands of a comparison operator are parameters, the derived type for each of them is VARCHAR, ...
https://dev.mysql.com/doc/refman/9.7/en/show-create-procedure.html
row *************************** Procedure: citycount sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION Create Procedure: CREATE DEFINER=`me`@`localhost` PROCEDURE ...
https://dev.mysql.com/doc/refman/9.7/en/show-procedure-status.html
row *************************** Db: test Name: sp1 Type: PROCEDURE Definer: testuser@localhost Modified: 2018-08-08 13:54:11 Created: 2018-08-08 13:54:11 Security_type: DEFINER Comment: character_set_client: utf8mb4 collation_connection: ... SHOW ...
https://dev.mysql.com/doc/refman/9.7/en/source-configuration-options.html
Use the SHOW COLLATION statement to determine which collations are available for each character set. This value can be set at server startup with the --collation_server option. The CMake program provides a great deal of control over how you ...
https://dev.mysql.com/doc/refman/9.7/en/xml-functions.html
Table 14.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in MySQL. Note It is possible to obtain ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-0-0.html
Character Set Support When resolving a call to the REPLACE() function, the character set and collation of the function result are copied from the first argument. This fix ensures that the third argument is also converted to the first argument's ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-3-0.html
(Bug #37591520) Use std::string_view rather than std::string when looking up character sets and collations, which saves on memory allocation and deallocation. (Bug #37560280) Collation name aliases were sometimes handled in case-sensitive fashion.
https://dev.mysql.com/doc/connectors/en/connector-cpp-apps-general-considerations.html
#if MYSQL_CONCPP_VERSION_NUMBER < 8000032 // this usage is OK; it compiles with 8.0.31 and all previous versions #endif When a Connector/C++ application that uses X DevAPI also uses the CharacterSet::utf8mb3 enumeration constant or any of the new ...