Ispirer Website Ispirer Capabilities - MySQL Migration Free Trial

MySQL Data Types - REAL

Versions: MySQL 5.x, 4.x and 3.23

MySQL - REAL
Syntax REAL[(p,s)] [UNSIGNED] [ZEROFILL]
Data Floating-point numeric data
Internals REAL is a synonym for DOUBLE. If the REAL_AS_FLOAT SQL mode is enabled, REAL is a synonym for FLOAT(p,s)
Standards ANSI SQL

MySQL REAL - Equivalents in Other Databases

Database Data Type and Conversion
Oracle FLOAT(24)
SQL Server REAL
PostgreSQL REAL
Sybase ASE REAL
Informix REAL, SMALLFLOAT
HP Neoview REAL
Ingres REAL

Related Data Types in MySQL

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

All Data Types


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