Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-national.html
For example, these data type declarations are equivalent: CHAR(10) CHARACTER SET utf8 NATIONAL CHARACTER(10) NCHAR(10) As are these: VARCHAR(10) CHARACTER SET utf8 NATIONAL VARCHAR(10) NVARCHAR(10) NCHAR VARCHAR(10) NATIONAL CHARACTER VARYING(10) ...
https://dev.mysql.com/doc/refman/8.4/en/charset-server.html
The server character set and collation are used as default values if the database character set and collation are not specified in CREATE DATABASE statements. MySQL Server has a server character set and a server collation. By default, these are ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-utf32.html
The utf32 character set is fixed length (like ucs2 and unlike utf16). utf32 uses 32 bits for every character, unlike ucs2 (which uses 16 bits for every character), and unlike utf16 (which uses 16 bits for some characters and 32 bits for others).
https://dev.mysql.com/doc/refman/8.4/en/checking-gpg-signature-windows.html
The Section 2.1.4.2, “Signature Checking Using GnuPG” section describes how to verify MySQL downloads using GPG. That guide also applies to Microsoft Windows, but another option is to use a GUI tool like Gpg4win. You may use a different tool ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-limitations.html
Local cloning operations do not support cloning of general tablespaces that were created with an absolute path. The clone plugin is subject to these limitations: An instance cannot be cloned from a different MySQL server series. For example, you ...
https://dev.mysql.com/doc/refman/8.4/en/comp-err.html
comp_err creates the errmsg.sys file that is used by mysqld to determine the error messages to display for different error codes. It compiles the errmsg.sys file from text-format error information in MySQL source distributions: The error ...
https://dev.mysql.com/doc/refman/8.4/en/comparison-operators.html
Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/doc/refman/8.4/en/corrupted-myisam-tables.html
You should try to create a reproducible test case that demonstrates the problem. Even though the MyISAM table format is very reliable (all changes to a table made by an SQL statement are written before the statement returns), you can still get ...
https://dev.mysql.com/doc/refman/8.4/en/cursor-restrictions.html
The same restrictions apply to internal temporary tables created to hold the result set for a cursor as for other uses of internal temporary tables. Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() function. A ...
https://dev.mysql.com/doc/refman/8.4/en/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...