Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Sybase Request SQLWays

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

Sybase ASE TINYINT - Equivalents in Other Databases

Database Data Type and Conversion
Oracle NUMBER(3,0), -103-1 to 103-1
SQL Server TINYINT, 0 to 255
MySQL TINYINT, Signed: -128 to 127, Unsigned: 0 to 255
PostgreSQL SMALLINT, -32768 to 32767
Informix SMALLINT, -32768 to 32767
HP Neoview SMALLINT, Signed: -32768 to 32767, Unsigned: 0 to 65535
Ingres TINYINT, -128 to 127

Related Data Types in Sybase ASE

Data Types
Integers BIGINT INT SMALLINT
Fixed-point DECIMAL(p,s) NUMERIC(p,s)
Floating-point FLOAT(p) REAL DOUBLE PRECISION

All Data Types


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Sybase Request SQLWays

sqlways/sybase/data-types/tinyint.txt · Last modified: May 07, 2018, 03:15:34 PM (external edit)
 
© 1999-2022, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement