https://wiki.ispirer.com/ 2026-05-18T10:42:41+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/neoview/data-types/char?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing HP Neoview Data Types - CHAR Versions: HP Neoview 2.4, 2.3 and 2.2 HP Neoview - CHAR Syntax CHAR[(n)] [CHARACTERS] Data Fixed-length character data, single-byte and multibyte character sets Parameters n is the maximum number of characters, optional text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/neoview/data-types/date?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing HP Neoview Data Types - DATE Versions: HP Neoview 2.4, 2.3 and 2.2 Neoview - DATE Syntax DATE Data Date data (year, month and day) Range January 01, 0001 to December 31, 9999 Storage Size 4 bytes Standards ANSI SQL Neoview DATE - Equivalents in Other Databases text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/neoview/data-types/decimal?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing HP Neoview Data Types - DECIMAL Versions: HP Neoview 2.4, 2.3 and 2.2 SQL Server - DECIMAL Syntax DECIMAL[(p[,s])] [SIGNED | UNSIGNED] Data Fixed-point numeric data stored as ASCII characters 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/neoview/data-types/double_precision?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing HP Neoview Data Types - DOUBLE PRECISION Versions: HP Neoview 2.4, 2.3 and 2.2 HP Neoview - DOUBLE PRECISION Syntax DOUBLE PRECISION Data Floating-point numeric data Range +/-2.225e-308 to +/-1.797e+308 Storage Size 8 bytes Standards text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/neoview/data-types/float?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing HP Neoview Data Types - FLOAT Versions: HP Neoview 2.4, 2.3 and 2.2 HP Neoview - FLOAT Syntax FLOAT[(p)] Data Floating-point numeric data Parameters p specifies the precision in binary digits Range +/-2.225e-308 to +/-1.797e+308, 1 <= text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/neoview/data-types/int?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing HP Neoview Data Types - INT, INTEGER Versions: HP Neoview 2.4, 2.3 and 2.2 HP Neoview - INT Syntax INT [SIGNED | UNSIGNED] Data 32-bit integer data Range Signed: -231 to 231-1 (2G) Unsigned: 0 to 232-1 (4G) Default The default is SIGNED text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/neoview/data-types/interval_day_time?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing HP Neoview Data Types - INTERVAL DAY/TIME Versions: HP Neoview 2.4, 2.3 and 2.2 HP Neoview - INTERVAL DAY/TIME Syntax INTERVAL [largest_qualifier[(p)] TO smallest_qualifier] Data Period of time in days and/or time. The largest_qualifier text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/neoview/data-types/interval_year_month?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing HP Neoview Data Types - INTERVAL YEAR/MONTH Versions: HP Neoview 2.4, 2.3 and 2.2 HP Neoview - INTERVAL Syntax INTERVAL [largest_qualifier[(p)] TO smallest_qualifier] Data Period of time in years and/or months. The largest_qualifier and text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/neoview/data-types/largeint?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing HP Neoview Data Types - LARGEINT Versions: HP Neoview 2.4, 2.3 and 2.2 SQL Server - LARGEINT Syntax LARGEINT Data 64-bit integer data Range -263 to 263-1 Storage Size 8 bytes Standards Neoview SQL Extension HP Neoview LARGEINT - Equivalents in Other Databases text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/neoview/data-types/nchar?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing HP Neoview Data Types - NCHAR Versions: HP Neoview 2.4, 2.3 and 2.2 HP Neoview - NCHAR Syntax NCHAR[(n)] Data Fixed-length character data in Unicode (UCS-2) or ISO88591 (Latin1) character set Parameters n is the maximum number of characters, optional text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/neoview/data-types/numeric?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing HP Neoview Data Types - NUMERIC Versions: HP Neoview 2.4, 2.3 and 2.2 SQL Server - NUMERIC Syntax NUMERIC[(p[,s])] [SIGNED | UNSIGNED] 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/neoview/data-types/nvarchar_n?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing HP Neoview Data Types - NVARCHAR Versions: HP Neoview 2.4, 2.3 and 2.2 HP Neoview - NVARCHAR Syntax NVARCHAR(n) Data Variable-length character data in Unicode (UCS-2) or ISO88591 (Latin1) character set Parameters n is the maximum number of characters, mandatory text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/neoview/data-types/real?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing HP Neoview Data Types - REAL Versions: HP Neoview 2.4, 2.3 and 2.2 HP Neoview - REAL Syntax REAL Data 23-bit floating-point numeric data Range +/-1.175e-38 to +/-3.402e+38 Storage Size 4 bytes Standards ANSI SQL HP Neoview REAL - Equivalents in Other Databases text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/neoview/data-types/smallint?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing HP Neoview Data Types - SMALLINT Versions: HP Neoview 2.4, 2.3 and 2.2 HP Neoview - SMALLINT Syntax SMALLINT [SIGNED | UNSIGNED] Data 16-bit integer data Range Signed: -32768 to 32767 Unsigned: 0 to 65535 Default The default is SIGNED text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/neoview/data-types/time?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing HP Neoview Data Types - TIME Versions: HP Neoview 2.4, 2.3 and 2.2 HP Neoview - TIME Syntax TIME[(p)] Data Time data (hours, minutes, seconds and fraction of seconds) Parameters p is the number of digits in the fractional part of second, 0 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/neoview/data-types/timestamp?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing HP Neoview Data Types - TIMESTAMP Versions: HP Neoview 2.4, 2.3 and 2.2 HP Neoview - TIMESTAMP Syntax TIMESTAMP[(p)] Data Date and time data (year, month, day, hours, minutes, seconds and fractional seconds) Parameters p specifies the number of digits in the fractional part of seconds text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/neoview/data-types/varchar_n?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing HP Neoview Data Types - VARCHAR Versions: HP Neoview 2.4, 2.3 and 2.2 HP Neoview - VARCHAR Syntax VARCHAR(n) [CHARACTERS] Data Variable-length character data, single-byte and multibyte character sets Parameters n is the maximum number of characters, mandatory