Ispirer Website Ispirer Capabilities - Microsoft SQL Server Migration Free Trial

SQL Server Data Types - REAL

Versions: SQL Server 2008, 2005, 2000, 7.0 and 6.5

SQL Server - REAL
Syntax REAL
Data Floating-point numeric data
Range 1E-38 to 1E+37
Notes REAL is equivalent to FLOAT(24)
Storage Size 4 bytes
Standards ANSI SQL

SQL Server REAL - Equivalents in Other Databases

Database Data Type and Conversion
Oracle FLOAT(24), BINARY_FLOAT
MySQL REAL(p,s)
PostgreSQL REAL
Sybase ASE REAL
Informix REAL, SMALLFLOAT
HP Neoview REAL
Ingres REAL

Related Data Types in SQL Server

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

All Data Types


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.