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