https://wiki.ispirer.com/ 2026-04-28T01:24:42+00:00 https://wiki.ispirer.com/ https://wiki.ispirer.com/lib/tpl/dokuwiki/images/favicon.ico text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types/bigint?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) Data Types - BIGINT Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x Informix - BIGINT Syntax BIGINT Data 64-bit integer data Range -263 to 263-1 Storage Size 8 bytes Synonyms INT8 (BIGINT has storage and processing advantages over INT8) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types/bigserial?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) Data Types - BIGSERIAL, SERIAL8 Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x Informix - BIGSERIAL Syntax BIGSERIAL[(n)] Data 64-bit auto-increment integer data, UNIQUE and PRIMARY KEY constraints text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types/blob?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) Data Types - BLOB Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x Infromix - BLOB Syntax BLOB Data Variable-length binary data (binary large object) Range 4 terabyte (4*240 bytes) Standards Informix SQL Extension text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types/boolean?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) Data Types - BOOLEAN Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x Informix - BOOLEAN Syntax BOOLEAN Data Boolean data Range 't', 'f' and NULL. 't' represents TRUE logical value, 'f' represents FALSE. Values are not case-sensitive, 't' is equivalent to 'T', 'f' to 'F' text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types/byte?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) Data Types - BYTE Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x Infromix - BYTE Syntax BYTE Data Variable-length binary data (binary large object) Range 2G Standards Informix SQL Extension Example: text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types/char?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) Data Types - CHAR Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x Informix DS - CHAR Syntax CHAR[(n)] Data Fixed-length character data, single-byte and multibyte character sets Parameters n is the maximum number of bytes, optional text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types/clob?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) Data Types - CLOB Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x Infromix - CLOB Syntax CLOB Data Variable-length character data (character large object), single-byte and multibyte character sets text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types/date?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) Data Types - DATE Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x Informix - DATE Syntax DATE Data Date data (year, month and day) Range January 01, 0001 to December 31, 9999 Standards ANSI SQL text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types/datetime?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) Data Types - DATETIME Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x Informix - DATETIME Syntax DATETIME [largest_qualifier TO smallest_qualifier] Data Date data and time (year, month, day, hours, minutes, seconds and fraction of seconds). text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types/decimal_numeric?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) Data Types - DECIMAL, NUMERIC Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x Informix - DECIMAL Syntax DECIMAL[(p[,s])] 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:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types/double_precision?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) Data Types - DOUBLE PRECISION Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x Informix - DOUBLE PRECISION Syntax DOUBLE PRECISION Data 64-bit floating-point numeric data Range 1E-308 to 1E+308 Notes text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types/float?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) Data Types - FLOAT Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x Informix - FLOAT Syntax FLOAT[(p)] Data 64-bit floating-point numeric data Parameters p is accepted for compliance with ANSI SQL, but ignored text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types/int?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) Data Types - INT, INTEGER Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x Informix - INT Syntax INT Data 32-bit integer data Range -231 to 231-1 (2G) Storage Size 4 bytes Synonyms INTEGER Standards text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types/interval_day_time?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) Data Types - INTERVAL DAY/TIME Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x Informix - INTERVAL Syntax INTERVAL [largest_qualifier[(n)] TO smallest_qualifier] Data Period of time in days and/or time. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types/interval_year_month?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) Data Types - INTERVAL YEAR/MONTH Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x Informix - INTERVAL Syntax INTERVAL [largest_qualifier[(n)] TO smallest_qualifier] Data Period of time in years and/or months. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types/lvarchar?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) Data Types - LVARCHAR Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x Infromix - LVARCHAR Syntax LVARCHAR[(n)] Data Variable-length character data, single-byte and multibyte character sets Parameters text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types/money?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) Data Types - MONEY Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x Informix - MONEY Syntax MONEY[(p[,s])] Data Monetary 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:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types/nchar?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) Data Types - NCHAR Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x Informix DS - NCHAR Syntax NCHAR[(n)] Data Fixed-length character data in the specified collation, single-byte and multibyte character sets text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types/nvarchar_n?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) Data Types - NVARCHAR Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x Infromix - NVARCHAR Syntax NVARCHAR[(n [,r])] Data Variable-length character data, single-byte and multibyte character sets Parameters text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types/real_smallfloat?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) Data Types - REAL, SMALLFLOAT Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x Informix - REAL Syntax REAL Data 32-bit floating-point numeric data Range 1E-38 to 1E+37 Synonyms SMALLFLOAT Storage Size text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types/serial?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) Data Types - SERIAL Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x Informix - SERIAL Syntax SERIAL[(n)] Data 32-bit auto-increment integer data, UNIQUE and PRIMARY KEY constraints are not automatically assigned text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types/smallint?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) Data Types - SMALLINT Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x Informix - SMALLINT Syntax SMALLINT Data 16-bit integer data Range -32768 to 32767 Storage Size 2 bytes Standards ANSI SQL text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types/text?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) Data Types - TEXT Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x Infromix - TEXT Syntax TEXT Data Variable-length character data (character large object), single-byte and multibyte character sets text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types/varchar_n?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) Data Types - VARCHAR Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x Infromix - VARCHAR Syntax VARCHAR[(n [,r])] Data Variable-length character data, single-byte and multibyte character sets Parameters