https://wiki.ispirer.com/ 2026-05-01T22:45:37+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/ingres/data-types/bigint?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Ingress Migration Pricing Ingres Data Types - BIGINT Versions: Ingres 9.x and 10.0 Ingres - BIGINT Syntax BIGINT Data 64-bit integer data Range -263 to 263-1 Storage Size 8 bytes Standards ANSI SQL Ingres BIGINT - Equivalents in Other Databases Database Data Type and Conversion text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/ingres/data-types/char?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Ingress Migration Pricing Ingres Data Types - CHAR Versions: Ingres 9.x and 10.0 Ingres - CHAR Syntax CHAR[(n)] Data Fixed-length character data, single-byte and multibyte character sets Parameters n is the maximum number of bytes, optional Range 1 ⇐ n ⇐ 32000 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/ingres/data-types/date?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Ingress Migration Pricing Ingres Data Types - DATE Versions: Ingres 9.x and 10.0 Ingres - DATE Syntax DATE Data Date data (year, month and day) Range 0001-01-01 to 9999-12-31 Storage Size 12 bytes Standards ANSI SQL Ingres DATE - Equivalents in Other Databases text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/ingres/data-types/decimal_numeric?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Ingress Migration Pricing Ingres Data Types - DECIMAL and NUMERIC Versions: Ingres 9.x and 10.0 Ingres - 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/ingres/data-types/float?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Ingress Migration Pricing Ingres Data Types - FLOAT Versions: Ingres 9.x and 10.0 Ingres - FLOAT Syntax FLOAT Data 64-bit floating-point numeric data Parameters 16 digit precision Range -1.0E+38 to +1.0E+38 Synonyms FLOAT8 Storage Size 8 bytes Standards ANSI SQL text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/ingres/data-types/int?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Ingress Migration Pricing Ingres Data Types - INTEGER Versions: Ingres 9.x and 10.0 Ingres - INTEGER Syntax INTEGER Data 32-bit integer data Range -231 to 231-1 Storage Size 4 bytes Synonyms INTEGER4, I4 Standards ANSI SQL Ingres INTEGER - Equivalents in Other Databases text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/ingres/data-types/long_nvarchar?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Ingress Migration Pricing Ingres Data Types - LONG NVARCHAR Versions: Ingres 9.x and 10.0 Ingres - LONG NVARCHAR Syntax LONG NVARCHAR Data Variable-length character data in the predefined character set - UTF8 Range 2G Notes These columns cannot be directly compared to other string data types. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/ingres/data-types/long_varchar?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Ingress Migration Pricing Ingres Data Types - LONG VARCHAR Versions: Ingres 9.x and 10.0 Ingres - LONG VARCHAR Syntax LONG VARCHAR Data Variable-length character data Range 2G Notes These columns cannot be directly compared to other string data types. To compare a long varchar column to another string data type, apply a coercion function. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/ingres/data-types/nchar?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Ingress Migration Pricing Ingres Data Types - NCHAR Versions: Ingres 9.x and 10.0 MySQL - NCHAR Syntax NCHAR[(n)] Data Fixed-length character data, single-byte and multibyte character sets - UTF8 Parameters n is the maximum number of characters, optional Range text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/ingres/data-types/nvarchar_n?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Ingress Migration Pricing Ingres Data Types - NVARCHAR Versions: Ingres 9.x and 10.0 Ingres - 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:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/ingres/data-types/real?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Ingress Migration Pricing Ingres Data Types - REAL Versions: Ingres 9.x and 10.0 Ingres - REAL Syntax REAL Data 32-bit floating-point numeric data Parameters 7 digit precision Range -1.0E+38 to +1.0E+38 Synonyms FLOAT4 Storage Size 4 bytes Standards ANSI SQL text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/ingres/data-types/smallint?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Ingress Migration Pricing Ingres Data Types - SMALLINT Versions: Ingres 9.x and 10.0 Ingres - SMALLINT Syntax SMALLINT Data 16-bit integer data Range -32768 to 32767 Storage Size 2 bytes Synonyms INTEGER2, I2 Standards ANSI SQL Ingres SMALLINT - Equivalents in Other Databases text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/ingres/data-types/text?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Ingress Migration Pricing Ingres Data Types - TEXT Versions: Ingres 9.x and 10.0 Ingres - TEXT Syntax TEXT[(n)] Data Variable-length character data, single-byte and multibyte character sets Parameters n is the maximum number of characters, optional Range 1 ⇐ n ⇐ 32000 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/ingres/data-types/time?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Ingress Migration Pricing Ingres Data Types - TIME Versions: Ingres 9.x and 10.0 Ingres - TIME Syntax TIME[(p)] [WITH|WITH LOCAL|WITHOUT TIME ZONE] Data Time data (hours, minutes, seconds) Parameters p indicates the number of digits of precision in the fractions of seconds, as an integer value from 0 to 9 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/ingres/data-types/timestamp?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Ingress Migration Pricing Ingres Data Types - TIMESTAMP Versions: Ingres 9.x and 10.0 Ingres - TIMESTAMP Syntax TIMESTAMP[(p)] [WITH|WITH LOCAL|WITHOUT TIME ZONE] Data Date and time data (year, month, day, hours, minutes, seconds and fractional seconds) Parameters text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/ingres/data-types/tinyint?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Ingress Migration Pricing Ingres Data Types - TINYINT Versions: Ingres 9.x and 10.0 Ingres - TINYINT Syntax TINYINT Data 8-bit integer data Range -128 to 127 Storage Size 1 byte Standards ANSI SQL Ingres TINYINT - Equivalents in Other Databases Database Data Type and Conversion text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/ingres/data-types/varchar?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Ingress Migration Pricing Ingres Data Types - VARCHAR Versions: Ingres 9.x and 10.0 Ingres - VARCHAR Syntax VARCHAR(n) Data Variable-length character data, single-byte and multibyte character sets Parameters n is the maximum number of characters, optional Range