http://www.ispirer.com/wiki/ 2010-09-10T08:14:19+04:00 http://www.ispirer.com/wiki/ http://www.ispirer.com/wiki/lib/images/favicon.ico text/html 2010-09-09T18:53:19+04:00 ispirer http://www.ispirer.com/wiki/sqlways/neoview/data-types?rev=1284043999&do=diff SQLWays Product Page - Migration to Neoview Free Evaluation Versions: HP Neoview 2.4, 2.3 and 2.2 Data Type Parameters and Range Character Data Types CHAR(n) - Fixed-length character data 1 <= n <= (32708 - size of other columns), default is 1 NCHAR(n) - Fixed-length character data in Unicode (UCS-2) or ISO88591 (Latin1) 1 <= n <= (32708 - size of other columns), default is 1 VARCHAR(n) - Variable-length character data 1 <= n <= (32708 - size of other columns), n is mandatory N… text/html 2010-09-09T18:25:24+04:00 ispirer http://www.ispirer.com/wiki/sqlways/sybase/data-types/smallmoney?rev=1284042324&do=diff SQLWays Product Page - Migration to Sybase Free Evaluation 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 Sybase Transact-SQL Extension Sybase ASE SMALLMONEY - Equivalents in Other Databases text/html 2010-09-09T18:25:05+04:00 ispirer http://www.ispirer.com/wiki/sqlways/sybase/data-types/money?rev=1284042305&do=diff SQLWays Product Page - Migration to Sybase Free Evaluation 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 Standards Sybase Transact-SQL Extension Sybase ASE MONEY - Equivalents in Other Databases text/html 2010-09-09T18:24:16+04:00 ispirer http://www.ispirer.com/wiki/sqlways/sql-server/data-types/smallmoney?rev=1284042256&do=diff SQLWays Product Page - Migration to SQL Server Free Evaluation Versions: SQL Server 2008, 2005, 2000, 7.0 and 6.5 SQL Server - SMALLMONEY Syntax SMALLMONEY Data Monetary data Range -214,748.3648 to 214,748.3647 Storage Size 4 bytes Standards SQL Server Extension SQL Server SMALLMONEY - Equivalents in Other Databases text/html 2010-09-09T18:22:47+04:00 ispirer http://www.ispirer.com/wiki/sqlways/informix/data-types/money?rev=1284042167&do=diff SQLWays Product Page - Informix Migration Free Evaluation 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 Range 1 <= p <= 32, 0 <= s <= p Default p is 16, s is 2 Notes Client applications format MONEY values according to the locale. For example, for the US, $ is used as … text/html 2010-09-09T18:15:54+04:00 ispirer http://www.ispirer.com/wiki/sqlways/postgresql/data-types/money?rev=1284041754&do=diff SQLWays Product Page - Migration to PostgreSQL Free Evaluation Versions: PostgreSQL 8.x and 7.x PostgreSQL - MONEY Syntax MONEY Data Monetary data Range -92,233,720,368,547,758.08 to 92,233,720,368,547,758.07 Storage Size 8 bytes Standards PostgreSQL Extension PostgreSQL MONEY - Equivalents in Other Databases text/html 2010-09-09T18:14:56+04:00 ispirer http://www.ispirer.com/wiki/sqlways/sql-server/data-types/money?rev=1284041696&do=diff SQLWays Product Page - Migration to SQL Server Free Evaluation Versions: SQL Server 2008, 2005, 2000, 7.0 and 6.5 SQL Server - MONEY Syntax MONEY Data Monetary data Range -922,337,203,685,477.5808 to 922,337,203,685,477.5807 Storage Size 8 bytes Standards SQL Server Extension SQL Server MONEY - Equivalents in Other Databases text/html 2010-09-09T17:59:55+04:00 ispirer http://www.ispirer.com/wiki/sqlways/informix/data-types?rev=1284040795&do=diff SQLWays Product Page - Migration to Informix Free Evaluation Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x Data Type Parameters and Range Character Data Types CHAR(n) - Fixed-length character data 1 <= n <= 32767, default is 1 NCHAR(n) - Fixed-length character data 1 <= n <= 32767, default is 1 VARCHAR(n,r) - Variable-length character data 1 <= n <= 255, default is 1; 0 <= r <= n, default is 0 NVARCHAR(n,r) - Variable-length character data 1 <= n <= 255, default is… text/html 2010-09-09T17:56:12+04:00 ispirer http://www.ispirer.com/wiki/sqlways/sybase/data-types/bit?rev=1284040572&do=diff SQLWays Product Page - Migration to Sybase Free Evaluation 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 Storage Size 1 byte for up to 8 bit columns Standards Sybase Transact-SQL Extension Sybase ASE BIT - Equivalents in Other Databases text/html 2010-09-09T17:55:59+04:00 ispirer http://www.ispirer.com/wiki/sqlways/postgresql/data-types/boolean?rev=1284040559&do=diff SQLWays Product Page - Migration to PostgreSQL Free Evaluation Versions: PostgreSQL 8.x and 7.x PostgreSQL - BOOLEAN Syntax BOOLEAN Data Boolean data Range TRUE, FALSE (they are PostgreSQL keywords) and NULL. Possible literal values for true state: TRUE, 'true', 't', 'yes', 'y' and '1'. Possible literal values for false state: FALSE, 'false', 'f', 'no', 'n' and '0' Error Handling Leading and trailing spaces are ignored Storage Size 1 byte Standards ANSI SQL PostgreSQL BOOLE… text/html 2010-09-09T17:55:41+04:00 ispirer http://www.ispirer.com/wiki/sqlways/mysql/data-types/bool?rev=1284040541&do=diff SQLWays Product Page - Migration to MySQL Free Evaluation 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 Storage Size 1 byte Synonyms BOOLEAN Standards MySQL Extension Example: text/html 2010-09-09T17:55:26+04:00 ispirer http://www.ispirer.com/wiki/sqlways/sql-server/data-types/bit?rev=1284040526&do=diff SQLWays Product Page - Migration to SQL Server Free Evaluation Versions: SQL Server 2008, 2005, 2000, 7.0 and 6.5 SQL Server - BIT Syntax BIT Data Boolean data Range 0, 1 and NULL. String value 'true' is converted to 1 and 'false' is converted to 0 Error Handling Values other than 0 and 1 are accepted but are always interpreted as 1 Storage Size 1 byte for up to 8 bit columns Standards SQL Server Extension SQL Server BIT - Equivalents in Other Databases text/html 2010-09-09T17:49:14+04:00 ispirer http://www.ispirer.com/wiki/sqlways/informix/data-types/boolean?rev=1284040154&do=diff SQLWays Product Page - Informix Migration Free Evaluation 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' Standards Informix SQL Extension Example: text/html 2010-09-09T17:40:14+04:00 ispirer http://www.ispirer.com/wiki/sqlways/sybase/data-types/image?rev=1284039614&do=diff SQLWays Product Page - Migration to Sybase Free Evaluation 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 Internals Data is stored in data pages that are separate from the rest of the table Standards Sybase Transact-SQL Extension Sybase ASE IMAGE - Equivalents in Other Databases text/html 2010-09-09T17:40:04+04:00 ispirer http://www.ispirer.com/wiki/sqlways/sybase/data-types/varbinary?rev=1284039604&do=diff SQLWays Product Page - Migration to Sybase Free Evaluation 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 Range 1 <= n <= pagesize (2K, 4K, 8K or 16K) Default n is 1 Trailing Zeros Removed when the value is stored Error Handling Exceeding data truncated without warning Storage Size Actual entry length Standards Syba… text/html 2010-09-09T17:39:53+04:00 ispirer http://www.ispirer.com/wiki/sqlways/sybase/data-types/binary?rev=1284039593&do=diff SQLWays Product Page - Migration to Sybase Free Evaluation 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 <= n <= pagesize (2K, 4K, 8K or 16K) Default n is 1 Padding Right-padded with 0 bytes to n only if NOT NULL Error Handling Exceeding data truncated without warning Storage Size n bytes Internals If defined as NUL… text/html 2010-09-09T17:39:31+04:00 ispirer http://www.ispirer.com/wiki/sqlways/postgresql/data-types/bytea?rev=1284039571&do=diff SQLWays Product Page - Migration to PostgreSQL Free Evaluation Versions: PostgreSQL 8.x and 7.x PostgreSQL - BYTEA Syntax BYTEA Data Variable-length binary data Range 231-1 bytes (2G) Standards PostgreSQL Extension PostgreSQL BYTEA - Equivalents in Other Databases text/html 2010-09-09T17:38:47+04:00 ispirer http://www.ispirer.com/wiki/sqlways/mysql/data-types/longblob?rev=1284039527&do=diff SQLWays Product Page - Migration to MySQL Free Evaluation 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 Error Handling Exceeding data truncated and a warning is generated if strict SQL mode is not enabled, otherwise an error is raised Storage Size Actual entry length Standards MySQL Ext… text/html 2010-09-09T17:38:31+04:00 ispirer http://www.ispirer.com/wiki/sqlways/mysql/data-types/mediumblob?rev=1284039511&do=diff SQLWays Product Page - Migration to MySQL Free Evaluation 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 Error Handling Exceeding data truncated and a warning is generated if strict SQL mode is not enabled, otherwise an error is raised Storage Size Actual entry length Synonyms… text/html 2010-09-09T17:38:16+04:00 ispirer http://www.ispirer.com/wiki/sqlways/mysql/data-types/blob?rev=1284039496&do=diff SQLWays Product Page - Migration to MySQL Free Evaluation 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 Error Handling Exceeding data truncated and a warning is generated if strict SQL mode is not enabled, otherwise an err…