https://wiki.ispirer.com/ 2026-05-13T19:39:50+00:00 https://wiki.ispirer.com/ https://wiki.ispirer.com/lib/tpl/dokuwiki/images/favicon.ico text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/bigint?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - BIGINT Versions: MySQL 5.x, 4.x and 3.23 MySQL - BIGINT Syntax BIGINT[(m)] [UNSIGNED] [ZEROFILL] Data 64-bit integer data Parameters m is the display width of data (not the value range constraint), optional. If the width of the value is less than m, the value is right-padded with spaces text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/binary?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - BINARY Versions: MySQL 5.x, 4.x and 3.23 MySQL - BINARY Syntax BINARY[(n)] Data Fixed-length binary data Parameters n is the maximum number of bytes, optional Range 0 <= n <= 255 Default n is 1 Padding Right-padded with 0 bytes to n text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/bit?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - BIT Versions: MySQL 5.x, 4.x and 3.23 MySQL - BIT Syntax BIT[(n)] Data Bit array Parameters n is the maximum number of bit values Range 1 <= n <= 64 Default n is 1 Notes b'value' notation can be used to assign values. For example, b'0101' text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/blob?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - BLOB Versions: MySQL 5.x, 4.x and 3.23 MySQL - BLOB Syntax BLOB[(n)] Data Variable-length binary data Parameters n is the maximum number of bytes, optional Range 65535 bytes or n if n is specified Trailing Zeros Not removed when the value is stored and retrieved. Trailing zeros are significant in comparisons text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/bool?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - BOOL Versions: MySQL 5.x, 4.x and 3.23 MySQL - BOOL Syntax BOOL Data Boolean data Range -128 to 127 and NULL. Values TRUE and FALSE (MySQL keywords) are supported but converted to 1 and 0, respectively Internals Implemented as TINYINT SIGNED text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/char?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - CHAR Versions: MySQL 5.x, 4.x and 3.23 MySQL - CHAR Syntax CHAR[(n)] [CHARACTER SET charset | BINARY | ASCII | UNICODE | BYTE] [COLLATE collate] Data Fixed-length character data, single-byte and multibyte character sets text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/date?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - DATE Versions: MySQL 5.x, 4.x and 3.23 MySQL - DATE Syntax DATE Data Date data (year, month and day) Range January 01, 1000 to December 31, 9999 Special Values MySQL DATE accepts zero date value '0000-00-00' (or 0, text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/datetime?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - DATETIME Versions: MySQL 5.x, 4.x and 3.23 MySQL - DATETIME Syntax DATETIME Data Date data and time (year, month, day, hours, minutes and seconds) Range January 01, 1000 00:00:00 to December 31, 9999 23:59:59 Special Values text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/decimal_numeric?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - DECIMAL and NUMERIC Versions: MySQL 5.x, 4.x and 3.23 MySQL - DECIMAL Syntax DECIMAL[(p[,s])] [UNSIGNED] [ZEROFILL] Data Fixed-point numeric data Parameters p is the maximum number of all digits (both sides of the decimal point), s is the maximum number of digits after the decimal point text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/double?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - DOUBLE Versions: MySQL 5.x, 4.x and 3.23 MySQL - DOUBLE Syntax DOUBLE[(p,s)] [UNSIGNED] [ZEROFILL] Data Floating-point numeric data Parameters p is the maximum number of all digits (both sides of the decimal point), s is the maximum number of digits after the point, optional text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/enum?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - ENUM Versions: MySQL 5.x, 4.x and 3.23 MySQL - ENUM Syntax ENUM('value1', 'value2', ...) Data Enumeration data is a string object that can have only one value from the list, NULL or the special '' error value Range Maximum 65,535 distinct values text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/float?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - FLOAT Versions: MySQL 5.x, 4.x and 3.23 MySQL - FLOAT Syntax FLOAT[(p[,s])] [UNSIGNED] [ZEROFILL] Data Floating-point numeric data Parameters If only p is specified, p is the binary precision. if p and s are both specified, p is the maximum number of all digits (both sides of the decimal point), text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/int?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - INT Versions: MySQL 5.x, 4.x and 3.23 MySQL - INT Syntax INT[(m)] [UNSIGNED] [ZEROFILL] Data 32-bit integer data Parameters m is the display width of data (not the value range constraint), optional. If the width of the value is less than m, the value is right-padded with spaces text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/longblob?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - LONGBLOB Versions: MySQL 5.x, 4.x and 3.23 MySQL - LONGBLOB Syntax LONGBLOB Data Variable-length binary data Range 4G (232 – 1) bytes Trailing Zeros Not removed when the value is stored and retrieved. Trailing zeros are significant in comparisons text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/longtext?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - LONGTEXT Versions: MySQL 5.x, 4.x and 3.23 MySQL - LONGTEXT Syntax LONGTEXT [CHARACTER SET charset | BINARY ] [COLLATE collate] Data Variable-length character data, single-byte and multibyte character sets Parameters CHARACTER SET specifies the character set, COLLATE specifies a collation for the character set. text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/mediumblob?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - MEDIUMBLOB Versions: MySQL 5.x, 4.x and 3.23 MySQL - MEDIUMBLOB Syntax MEDIUMBLOB Data Variable-length binary data Range 16,777,215 (224 – 1) bytes Trailing Zeros Not removed when the value is stored and retrieved. Trailing zeros are significant in comparisons text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/mediumint?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - MEDIUMINT Versions: MySQL 5.x, 4.x and 3.23 MySQL - MEDIUMINT Syntax MEDIUMINT[(m)] [UNSIGNED] [ZEROFILL] Data 24-bit integer data Parameters m is the display width of data (not the value range constraint), optional. If the width of the value is less than m, the value is right-padded with spaces text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/mediumtext?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - MEDIUMTEXT Versions: MySQL 5.x, 4.x and 3.23 MySQL - MEDIUMTEXT Syntax MEDIUMTEXT [CHARACTER SET charset | BINARY ] [COLLATE collate] Data Variable-length character data, single-byte and multibyte character sets Parameters text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/nchar?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - NCHAR Versions: MySQL 5.x, 4.x and 3.23 MySQL - NCHAR Syntax NCHAR[(n)] Data Fixed-length character data in the predefined character set - UTF8 Parameters n is the maximum number of characters, optional Range 0 <= n text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/nvarchar_n?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - NVARCHAR Versions: MySQL 5.x, 4.x and 3.23 MySQL - NVARCHAR Syntax NVARCHAR(n) Data Variable-length character data in the predefined character set - UTF8 Parameters n is the maximum number of characters, optional Range text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/real?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - REAL Versions: MySQL 5.x, 4.x and 3.23 MySQL - REAL Syntax REAL[(p,s)] [UNSIGNED] [ZEROFILL] Data Floating-point numeric data Internals REAL is a synonym for DOUBLE. If the REAL_AS_FLOAT SQL mode is enabled, REAL is a synonym for text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/set?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - SET Versions: MySQL 5.x, 4.x and 3.23 MySQL - SET Syntax SET('value1', 'value2', ...) Data A set of zero or more of string values Range Maximum 64 values Internals SET is represented internally as integers Standards text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/smallint?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - SMALLINT Versions: MySQL 5.x, 4.x and 3.23 MySQL - SMALLINT Syntax SMALLINT[(m)] [UNSIGNED] [ZEROFILL] Data 16-bit integer data Parameters m is the display width of data (not the value range constraint), optional. If the width of the value is less than m, the value is right-padded with spaces text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/text?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - TEXT Versions: MySQL 5.x, 4.x and 3.23 MySQL - TEXT Syntax TEXT[(n)] [CHARACTER SET charset | BINARY ] [COLLATE collate] Data Variable-length character data, single-byte and multibyte character sets Parameters n is the maximum number of characters, optional. CHARACTER SET specifies the character set, COLLATE specifies a collation for the character set. text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/time?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - TIME Versions: MySQL 5.x, 4.x and 3.23 MySQL - TIME Syntax TIME Data Time data (hours, minutes and seconds) Range -838:59:59 to 838:59:59 Storage Size 3 bytes Standards ANSI SQL MySQL TIME - Equivalents in Other Databases text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/timestamp?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - TIMESTAMP Versions: MySQL 5.x, 4.x and 3.23 MySQL - TIMESTAMP Syntax TIMESTAMP Data Auto-updated date and time data (day, month, year, hours, minutes and seconds) The first TIMESTAMP column is set to the date and time of the most recent UPDATE or INSERT operation if you do not assign a value or specify NULL text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/tinyblob?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - TINYBLOB Versions: MySQL 5.x, 4.x and 3.23 MySQL - TINYBLOB Syntax TINYBLOB Data Variable-length binary data Range 255 bytes Trailing Zeros Not removed when the value is stored and retrieved. Trailing zeros are significant in comparisons text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/tinyint?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - TINYINT Versions: MySQL 5.x, 4.x and 3.23 MySQL - TINYINT Syntax TINYINT[(m)] [UNSIGNED] [ZEROFILL] Data 8-bit integer data Parameters m is the display width of data (not the value range constraint), optional. If the width of the value is less than m, the value is right-padded with spaces text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/tinytext?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - TINYTEXT Versions: MySQL 5.x, 4.x and 3.23 MySQL - TINYTEXT Syntax TINYTEXT [CHARACTER SET charset | BINARY ] [COLLATE collate] Data Variable-length character data, single-byte and multibyte character sets Parameters CHARACTER SET specifies the character set, COLLATE specifies a collation for the character set. text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/varbinary?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - VARBINARY Versions: MySQL 5.x, 4.x and 3.23 MySQL - VARBINARY Syntax VARBINARY(n) Data Variable-length binary data Parameters n is the maximum number of bytes, optional Range 1 <= n <= 65535 (maximum row size shared among all columns) text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/varchar_n?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - VARCHAR Versions: MySQL 5.x, 4.x and 3.23 MySQL - VARCHAR Syntax VARCHAR(n) [CHARACTER SET charset | BINARY | ASCII | UNICODE ] [COLLATE collate] Data Variable-length character data, single-byte and multibyte character sets text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types/year?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types - YEAR Versions: MySQL 5.x, 4.x and 3.23 MySQL - YEAR Syntax YEAR[(2|4)] Data Year data Range 4 digit format: 1901 to 2155 and 0; 2 digit format: 70 to 69 (1970 to 2069) Default 4 digit format Storage Size 1 byte