Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-national.html
Standard SQL defines NCHAR or NATIONAL CHAR as a way to indicate that a CHAR column should use some predefined character set. For example, these data type declarations are equivalent: CHAR(10) CHARACTER SET utf8 NATIONAL CHARACTER(10) NCHAR(10) As ...Please consider using CHAR(x) CHARACTER SET UTF8MB4 in order to be ...
https://dev.mysql.com/doc/refman/8.4/en/char.html
The CHAR and VARCHAR types are similar, but differ in the way they are stored and retrieved. The CHAR and VARCHAR types are declared with a length that indicates the maximum number of characters you want to store. The length of a CHAR column is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-tpch-quickstart.html
It is assumed that sample data fields are terminated by the pipe "|" character. The query lists the nations in ascending alphabetical order and, for each nation, the year and profit in descending order by year (most recent first). mysql-sql> USE ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-recattr-vs-ndbrecord.html
This example illustrates the key differences between the old-style NdbRecAttr API and the newer approach using NdbRecord when performing some common tasks in an NDB API application. The source code can be found can be found in the file ...
https://dev.mysql.com/doc/refman/8.4/en/string-type-syntax.html
[NATIONAL] CHAR[(M)] [CHARACTER SET charset_name] [COLLATE collation_name] A fixed-length string that is always right-padded with spaces to the specified length when stored. NATIONAL CHAR (or its equivalent short form, NCHAR) is the standard SQL way ... The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and ...In some cases, MySQL may change a ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
The EXPLAIN plan output shows that there is no common predicate between the first two table entries (NATION and SUPPLIER). mysql> EXPLAIN SELECT o_orderkey, c_custkey, l_shipdate, s_nationkey, s_suppkey, l_comment FROM lineitem, supplier, nation, ...
https://dev.mysql.com/doc/ndbapi/en/ndbapi-examples-array-simple.html
This program inserts CHAR, VARCHAR, and BINARY column data into a table by constructing aRef objects using local functions. strncpy (data.attr3 + 1, meter.c_str(), i); // Set the length byte data.attr3[0] = (char)i; // Fill VARCHAR(500) with 20*i ...It then reads the columns back and extracts the data from them using local ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndboperation.html
This method and branch_col_notlike() each support the wildcards used by the MySQL LIKE operator: % for any string of 0 or more characters, and _ for any single character. The column's type must be one of CHAR, VARCHAR, BINARY, or VARBINARY. This ...
https://dev.mysql.com/doc/refman/8.4/en/string-functions.html
All international alphabetic characters outside the A-Z range are treated as vowels. ASCII(str) Returns the numeric value of the leftmost character of the string str. [USING charset_name]) CHAR() interprets each argument N as an integer and returns ...For functions that operate on string positions, the first position is numbered ...
https://dev.mysql.com/doc/ndbapi/en/ndbapi-examples-common-files.html
(Bug #70550, Bug #17592990) The names of these files are listed here: array_adapter.hpp: Contains utility classes for converting between C++ style strings or byte arrays and the format used by NDB internally for VARCHAR, CHAR, and VARBINARY types.