https://wiki.ispirer.com/ 2026-04-28T01:20:31+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/sybase/data-types/bigint?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - BIGINT Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x Sybase ASE - BIGINT Syntax [UNSIGNED] BIGINT Data 64-bit integer data Range Signed: -263 to 263-1, Unsigned: 0 to 264-1 Storage Size text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sybase/data-types/binary?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - BINARY Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x Sybase ASE - BINARY Syntax BINARY[(n)] Data Fixed-length binary data Parameters n is the maximum number of bytes, optional Range 1 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sybase/data-types/bit?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - BIT Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x Sybase ASE - BIT Syntax BIT Data Boolean data Range 0 and 1 only (NULL is not allowed) Error Handling Values other than 0 and 1 are accepted but are always interpreted as 1 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sybase/data-types/char?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - CHAR Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x Sybase ASE - CHAR Syntax CHAR[(n)] Data Fixed-length character data, single-byte and multibyte character sets Parameters n is the maximum number of text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sybase/data-types/date?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - DATE Versions: Sybase Adaptive Server Enterprise 15.x and 12.5.x Sybase ASE - DATE Syntax DATE Data Date data (year, month and day) Range January 01, 0001 to December 31, 9999 Storage Size 4 bytes Version Differences text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sybase/data-types/datetime?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - DATETIME Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x Sybase ASE - DATETIME Syntax DATETIME Data Date and time data (year, month, day, hours, minutes, seconds and 1/300 seconds) Range January 01, 1753 00:00:00.000 to December 31, 9999 23:59:59.997 with accuracy 1/300 second text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sybase/data-types/decimal_numeric?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - DECIMAL and NUMERIC Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x Sybase ASE - NUMERIC Syntax NUMERIC[(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/sybase/data-types/double_precision?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - DOUBLE PRECISION Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x Sybase ASE - DOUBLE PRECISION Syntax DOUBLE PRECISION Data Floating-point numeric data Range Machine dependent Storage Size text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sybase/data-types/float?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - FLOAT Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x Sybase ASE - FLOAT Syntax FLOAT[(p)] Data Floating-point numeric data Parameters p is the binary precision Range Machine dependent text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sybase/data-types/image?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - IMAGE Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x Sybase ASE - IMAGE Syntax IMAGE Data Variable-length binary data Range 231-1 bytes (2G) Storage Size 0 bytes when empty, otherwise multiple of 2K text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sybase/data-types/int?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - INT Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x Sybase ASE - INT Syntax [UNSIGNED] INT Data 32-bit integer data Range Signed: -231 to 231-1 (2G), Unsigned: 0 to 232-1 (4G) Storage Size text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sybase/data-types/money?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - MONEY Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x Sybase ASE - MONEY Syntax MONEY Data Monetary data Range -922,337,203,685,477.5808 to 922,337,203,685,477.5807 Storage Size 8 bytes text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sybase/data-types/nchar?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - NCHAR Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x Sybase ASE - NCHAR Syntax NCHAR[(n)] Data Fixed-length character data, single-byte and multibyte character sets Parameters n is the maximum number of text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sybase/data-types/nvarchar_n?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - NVARCHAR Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x Sybase ASE - NVARCHAR Syntax NVARCHAR[(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/sybase/data-types/real?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - REAL Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x Sybase ASE - REAL Syntax REAL Data Floating-point numeric data Range Machine dependent Storage Size 4 bytes Standards ANSI SQL Sybase ASE REAL - Equivalents in Other Databases text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sybase/data-types/smalldatetime?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - SMALLDATETIME Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x Sybase ASE - SMALLDATETIME Syntax SMALLDATETIME Data Date and time data (year, month, day, hours and minutes) Range January 01, 1900 00:00 to June 06, 2079 23:59 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sybase/data-types/smallint?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - SMALLINT Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x Sybase ASE - SMALLINT Syntax [UNSIGNED] SMALLINT Data 16-bit integer data Range Signed: -32,768 to 32,767, Unsigned: 0 to 65535 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sybase/data-types/smallmoney?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - SMALLMONEY Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x Sybase ASE - SMALLMONEY Syntax SMALLMONEY Data Monetary data Range -214,748.3648 to 214,748.3647 Storage Size 4 bytes Standards text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sybase/data-types/text?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - TEXT Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x Sybase ASE - TEXT Syntax TEXT Data Variable-length character data Range 231-1 bytes (2G) Storage Size 0 bytes when empty, otherwise multiple of 2K text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sybase/data-types/time?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - TIME Versions: Sybase Adaptive Server Enterprise 15.x and 12.5.x Sybase ASE - TIME Syntax TIME Data Time data (hours, minutes, seconds and milliseconds) Range 00:00:00.000 to 23:59:59.999 Storage Size 4 bytes text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sybase/data-types/timestamp?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - TIMESTAMP Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x Sybase ASE - TIMESTAMP Syntax TIMESTAMP Data Binary data that is automatically updated each time the row is modified Notes A table can have only one TIMESTAMP column text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sybase/data-types/tinyint?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - TINYINT Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x Sybase ASE - TINYINT Syntax TINYINT Data 8-bit integer data Range 0 to 255 Storage Size 1 byte Standards Sybase Transact-SQL Extension text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sybase/data-types/unichar?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - UNICHAR Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x Sybase ASE - UNICHAR Syntax UNICHAR[(n)] Data Fixed-length character data, Unicode character set Parameters n is the maximum number of text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sybase/data-types/unitext?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - UNITEXT Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x Sybase ASE - UNITEXT Syntax UNITEXT Data Variable-length character data, Unicode character set Range 2G Storage Size 0 bytes when empty, otherwise multiple of 2K text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sybase/data-types/univarchar?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - UNIVARCHAR Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x Sybase ASE - UNIVARCHAR Syntax UNIVARCHAR[(n)] Data Variable-length character data, Unicode character set Parameters n is the maximum number of text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sybase/data-types/varbinary?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - VARBINARY Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x Sybase ASE - VARBINARY Syntax VARBINARY[(n)] Data Variable-length binary data 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/sybase/data-types/varchar_n?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Sybase Migration Pricing Sybase ASE Data Types - VARCHAR Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x Sybase ASE - VARCHAR Syntax VARCHAR[(n)] Data Variable-length character data, single-byte and multibyte character sets Parameters n is the maximum number of