Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-column.html
Every “character” column (that is, a column of type CHAR, VARCHAR, a TEXT type, or any synonym) has a column character set and a column collation. CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ) CHARACTER SET ...
https://dev.mysql.com/doc/refman/8.4/en/charset-introducer.html
A character string literal, hexadecimal literal, or bit-value literal may have an optional character set introducer and COLLATE clause, to designate it as a string that uses a particular character set and collation: [_charset_name] literal [COLLATE ...
https://dev.mysql.com/doc/refman/8.4/en/charset-database.html
Every database has a database character set and a database collation. The CREATE DATABASE and ALTER DATABASE statements have optional clauses for specifying the database character set and collation: CREATE DATABASE db_name [[DEFAULT] CHARACTER SET ...
https://dev.mysql.com/doc/refman/8.4/en/charset-conversion.html
To convert a binary or nonbinary string column to use a particular character set, use ALTER TABLE. For successful conversion to occur, one of the following conditions must apply: If the column has a binary data type (BINARY, VARBINARY, BLOB), all ...
https://dev.mysql.com/doc/refman/8.4/en/charset-configuration.html
The MySQL server has a compiled-in default character set and collation. To change these defaults, use the --character-set-server and --collation-server options when you start the server. The collation must be a legal collation for the default ...
https://dev.mysql.com/doc/refman/8.4/en/charset-repertoire.html
The repertoire of a character set is the collection of characters in the set. String expressions have a repertoire attribute, which can have two values: ASCII: The expression can contain only ASCII characters; that is, characters in the Unicode ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-charsets.html
Setting the Character Encoding For Connector/J 8.0.25 and earlier: The character encoding between the client and the server is automatically detected upon connection (provided that the Connector/J connection properties characterEncoding and ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-charsets.html
Setting the Character Encoding For Connector/J 8.0.25 and earlier: The character encoding between the client and the server is automatically detected upon connection (provided that the Connector/J connection properties characterEncoding and ...
https://dev.mysql.com/doc/refman/8.4/en/charset-mysql.html
MySQL Server supports multiple character sets, including several Unicode character sets. To display the available character sets, use the INFORMATION_SCHEMA CHARACTER_SETS table or the SHOW CHARACTER SET statement. For more complete information, ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-postgresql-typemapping.html
The following table shows the mapping between PostgreSQL (source) data types and MySQL data types. Table 10.3 Type mapping Source Type MySQL Type Comment INT INT SMALLINT SMALLINT BIGINT BIGINT SERIAL INT Sets AUTO_INCREMENT in its table definition. BIT BIT BOOLEAN TINYINT(1) REAL FLOAT DOUBLE PRECISION DOUBLE NUMERIC DECIMAL DECIMAL DECIMAL MONEY DECIMAL(19,2) CHAR CHAR/LONGTEXT Depending on its ...