Search Results
MySQL 8.4 Reference Manual :: A.11 MySQL 8.4 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
https://dev.mysql.com/doc/refman/8.4/en/faqs-cjk.html
This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK (Chinese-Japanese-Korean) issues. What problems should I be aware of when working with the Big5 ...
https://dev.mysql.com/doc/refman/8.4/en/features.html
Data Types Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS spatial types. This section describes some ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-natural-language.html
| 1.3114095926285 | +----+-------------------------------------+-----------------+ 2 rows in set (0.00 sec) A phrase that is enclosed within double quote (") characters matches only rows that contain the phrase literally, as it was typed. By ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search.html
There are no special operators, with the exception of double quote (") characters. MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE ...
https://dev.mysql.com/doc/refman/8.4/en/gis-class-geometry.html
Its coordinates in its spatial reference system, represented as double-precision (8-byte) numbers. It is a noninstantiable class but has a number of properties, described in the following list, that are common to all geometry values created from any ...
https://dev.mysql.com/doc/refman/8.4/en/gis-linestring-property-functions.html
You can extract particular points of a LineString, count the number of points that it contains, or obtain its length. Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL or any ...
https://dev.mysql.com/doc/refman/8.4/en/gis-polygon-property-functions.html
These functions are available for obtaining polygon properties: ST_Area({poly|mpoly}) Returns a double-precision number indicating the area of the Polygon or MultiPolygon argument, as measured in its spatial reference system. Functions in this ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-mapping.html
There is a correspondence between database and table identifiers and names in the file system. For the basic structure, MySQL represents each database as a directory in the data directory, and depending upon the storage engine, each table may be ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-columns-table.html
1 = VARCHAR, 2 = CHAR, 3 = FIXBINARY, 4 = BINARY, 5 = BLOB, 6 = INT, 7 = SYS_CHILD, 8 = SYS, 9 = FLOAT, 10 = DOUBLE, 11 = DECIMAL, 12 = VARMYSQL, 13 = MYSQL, 14 = GEOMETRY. For related usage information and examples, see Section 17.15.3, “InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-internals.html
Image data, such as JPEG, is typically already compressed and so does not benefit much from being stored in a compressed table; the double compression can waste CPU cycles for little or no space savings. This section describes some internal ...