Ispirer Website
Ispirer Capabilities - Informix Migration
Free Trial
Informix Dynamic Server (IDS) Data Types - BIGSERIAL, SERIAL8
Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x
| Informix - BIGSERIAL | |
|---|---|
| Syntax | BIGSERIAL[(n)] |
| Data | 64-bit auto-increment integer data, UNIQUE and PRIMARY KEY constraints are not automatically assigned UPDATE statement cannot be used to change an existing serial value To insert an explicit value, specify any integer greater than zero in INSERT statement. If you specify 0 then the next serial value will be assigned |
| Parameters | n is the starting number |
| Default | n is 1 |
| Range | 1 to 263-1, negative values are not allowed |
| Storage Size | 8 bytes |
| Synonyms | SERIAL8 |
| Internals | BIGSERIAL is implemented as BIGINT, SERIAL8 is implemented as INT8 (BIGINT has storage and processing advantages over INT8) |
| Standards | Informix SQL Extension |
Example:
CREATE TABLE t_serial (c1 BIGSERIAL);
Informix BIGSERIAL - Equivalents in Other Databases
| Database | Data Type and Conversion |
|---|---|
| Oracle | NUMBER(19,0) with SEQUENCE object |
| SQL Server | BIGINT with IDENTITY property |
| MySQL | BIGINT with AUTO_INCREMENT property |
| PostgreSQL | BIGSERIAL |
| Sybase ASE | NUMERIC(10,0) with IDENTITY property |
Related Data Types in Informix
All Data Types