Ispirer Website Ispirer Capabilities - PostgreSQL Migration Free Trial

PostgreSQL Data Types - TEXT

Versions: PostgreSQL 8.x and 7.x

PostgreSQL - TEXT
Syntax TEXT
Data Variable-length character data
Range 1G
Trailing Spaces Not removed when the value is stored and retrieved. Trailing spaces are significant in comparison.
Character Set Database default
Storage Size actual entry length
Standards PostgreSQL Extension

PostgreSQL TEXT - Equivalents in Other Databases

Database Data Type and Conversion
Oracle CLOB, 4G; NCLOB, 4G, Unicode - UTF-8 or UTF-16
SQL Server VARCHAR(n | max), 1 ⇐ n ⇐ 8000, 2G if max is specified
MySQL LONGTEXT, 4G
Sybase ASE TEXT, 2G
Informix TEXT, 2G, CLOB, 4T
HP Neoview VARCHAR(n), 1 ⇐ n ⇐ (32708 - size of other columns)
Ingres LONG VARCHAR, 2G; LONG NVARCHAR, 2G, Unicode - UTF-8

Related Data Types in PostgreSQL

Data Types
Fixed-length character data CHAR(n)
Variable-length character data VARCHAR(n)

All Data Types


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