Differences

This shows you the differences between two versions of the page.

--- sybase-asa-to-postgresql [July 09, 2026 11:26 am]
sqlines
+++ sybase-asa-to-postgresql [July 27, 2026 12:20 pm] (current)
sqlines
@@ Line 42: / Line 42: @@
 | 7 | TIMESTAMP WITH TIME ZONE | Date and time with fraction and time zone | TIMESTAMP WITH TIME ZONE |
-Converting data types:
+Numeric data types:
 | | **Sybase SQL Anywhere** || **PostgreSQL** |
 | 1 | BIGINT | 64-bit integer | BIGINT |
-| 2 | BINARY(//n//) | Variable-length binary string, 1 <= //n// <= 32767 | BYTEA |
+| 2 | DECIMAL(//p,s//), DEC(//p,s//) | Fixed point number | DECIMAL(//p,s//), DEC(//p,s//) |
-| 3 | BINARY VARYING(//n//) | Variable-length binary string, 1 <= //n// <= 32767 | BYTEA |
+| 3 | DOUBLE [PRECISION] | Double-precision floating-point number | DOUBLE PRECISION |
-| 4 | CHAR(//n//), CHARACTER(//n//) | Fixed-length string, 1 <= //n// <= 32767 | CHAR(//n//), CHARACTER(//n//) |
+| 4 | FLOAT(//p//) | Floating-point number | DOUBLE PRECISION |
-| 5 | DECIMAL(//p,s//), DEC(//p,s//) | Fixed point number | DECIMAL(//p,s//), DEC(//p,s//) |
+| 5 | INTEGER, INT | 32-bit integer | INTEGER, INT |
-| 6 | DOUBLE [PRECISION] | Double-precision floating-point number | DOUBLE PRECISION |
+| 6 | MONEY | Monetary data | MONEY |
-| 7 | FLOAT(//p//) | Floating-point number | DOUBLE PRECISION |
+| 7 | NUMERIC(//p,s//) | Fixed point number | NUMERIC(//p,s//) |
-| 8 | IMAGE | Binary data, <= 2G | BYTEA |
+| 8 | REAL | Single-precision floating-point number | REAL |
-| 9 | INTEGER, INT | 32-bit integer | INTEGER, INT |
+| 9 | SMALLINT | 16-bit integer | SMALLINT |
-| 10 | LONG BINARY | Binary data, <= 2G | BYTEA |
+| 10 | SMALLMONEY | Monetary data, <= million currency units | MONEY |
-| 11 | LONG BIT VARYING | Bit array data, <= 2G | BYTEA |
+| 11 | TINYINT | 8-bit unsigned integer, 0 to 255 {{:exclamation.png|}} | SMALLINT |
-| 12 | LONG NVARCHAR | UTF-8 character data, <= 2G {{:exclamation.png|}} | TEXT |
+| 12 | UNSIGNED BIGINT | 64-bit unsigned integer {{:exclamation.png|}} | NUMERIC(20) |
-| 13 | LONG VARBIT | Bit array data, <= 2G | BYTEA |
+| 13 | UNSIGNED INT | 32-bit unsigned integer {{:exclamation.png|}} | NUMERIC(10) |
-| 14 | LONG VARCHAR | Character data, <= 2G {{:exclamation.png|}} | TEXT |
+| 14 | UNSIGNED SMALLINT | 16-bit unsigned integer {{:exclamation.png|}} | NUMERIC(5) |
-| 15 | MONEY | Monetary data | MONEY |
+| 15 | UNSIGNED TINYINT | 8-bit unsigned integer {{:exclamation.png|}} | NUMERIC(3) |
-| 16 | NCHAR(//n//) | Fixed-length UTF-8 string, 1 <= //n// <= 32767 | CHAR(//n//) |
-| 17 | NTEXT | UTF-8 character data, <= 2G {{:exclamation.png|}} | TEXT |
+Converting data types:
-| 18 | NUMERIC(//p,s//) | Fixed point number | NUMERIC(//p,s//) |
-| 19 | NVARCHAR(//n//) | Variable-length UTF-8 string, 1 <= //n// <= 32767 | VARCHAR(//n//) |
+| | **Sybase SQL Anywhere** || **PostgreSQL** |
-| 20 | REAL | Single-precision floating-point number | REAL |
+| 1 | BINARY(//n//) | Variable-length binary string, 1 <= //n// <= 32767 | BYTEA |
-| 21 | SMALLINT | 16-bit integer | SMALLINT |
+| 2 | BINARY VARYING(//n//) | Variable-length binary string, 1 <= //n// <= 32767 | BYTEA |
-| 22 | SMALLMONEY | Monetary data, <= million currency units | MONEY |
+| 3 | CHAR(//n//), CHARACTER(//n//) | Fixed-length string, 1 <= //n// <= 32767 | CHAR(//n//), CHARACTER(//n//) |
-| 23 | TEXT | Character data, <= 2G {{:exclamation.png|}} | TEXT |
+| 4 | IMAGE | Binary data, <= 2G | BYTEA |
-| 24 | TINYINT | 8-bit unsigned integer, 0 to 255 {{:exclamation.png|}} | SMALLINT |
+| 5 | LONG BINARY | Binary data, <= 2G | BYTEA |
-| 25 | UNSIGNED BIGINT | 64-bit unsigned integer {{:exclamation.png|}} | NUMERIC(20) |
+| 6 | LONG BIT VARYING | Bit array data, <= 2G | BYTEA |
-| 26 | UNSIGNED INT | 32-bit unsigned integer {{:exclamation.png|}} | NUMERIC(10) |
+| 7 | LONG NVARCHAR | UTF-8 character data, <= 2G {{:exclamation.png|}} | TEXT |
-| 27 | UNSIGNED SMALLINT | 16-bit unsigned integer {{:exclamation.png|}} | NUMERIC(5) |
+| 8 | LONG VARBIT | Bit array data, <= 2G | BYTEA |
-| 28 | UNSIGNED TINYINT | 8-bit unsigned integer {{:exclamation.png|}} | NUMERIC(3) |
+| 9 | LONG VARCHAR | Character data, <= 2G {{:exclamation.png|}} | TEXT |
-| 29 | VARBINARY(//n//) | Variable-length binary string, 1 <= //n// <= 32767 | BYTEA |
+| 10 | NCHAR(//n//) | Fixed-length UTF-8 string, 1 <= //n// <= 32767 | CHAR(//n//) |
-| 30 | VARCHAR(//n//) | Variable-length string, 1 <= //n// <= 32767 | VARCHAR(//n//) |
+| 11 | NTEXT | UTF-8 character data, <= 2G {{:exclamation.png|}} | TEXT |
+| 12 | NVARCHAR(//n//) | Variable-length UTF-8 string, 1 <= //n// <= 32767 | VARCHAR(//n//) |
+| 13 | TEXT | Character data, <= 2G {{:exclamation.png|}} | TEXT |
+| 14 | VARBINARY(//n//) | Variable-length binary string, 1 <= //n// <= 32767 | BYTEA |
+| 15 | VARCHAR(//n//) | Variable-length string, 1 <= //n// <= 32767 | VARCHAR(//n//) |
 Other data types:

SQLines Data

SQLines SQL Converter

Migration to MariaDB

Migration to MySQL

Migration to PostgreSQL

Migration to SQL Server

Migration to Oracle

SQL in Applications

Differences