SQL Dialects Reference/Data structure definition/Data types/Character types

Character typesEdit

This page includes comparison tables which can be big and complex.

While it's perfectly all right to view them in their complete state, it is recommended to install a comparison tables extension that would allow to select particular columns of interest for comparison.

SQL version Feature Standard
SQL:2011
DB2 Firebird Ingres Linter MSSQL MySQL MonetDB Oracle
Vers. 11.x
PostgreSQL SQLite Virtuoso
 ? Variable-length with limit VARCHAR(n) VARCHAR(n) VARCHAR(n) VARCHAR(n)
NVARCHAR(n)
VARCHAR(n)
NVARCHAR(n)
VARCHAR(n)
NVARCHAR(n)
VARCHAR(n) VARCHAR(n)
CHARACTER VARYING(n)
VARCHAR2(n)
VARCHAR(n) is slated for deprecation
character varying(n)
varchar(n)
VARCHAR(n) VARCHAR(n)
 ? Variable-length with limit, max size no limit  ? 32765  ?  ? 8000 65535  ?  ? about 1 GB  ?  ?
 ? Fixed-length, blank padded string CHAR(n) CHAR(n) CHAR(n) CHAR(n)
NCHAR(n)
CHAR(n)
NCHAR(n)
CHAR(n)
NCHAR(n)
CHAR(n)  ? CHAR(n) character(n)
char(n)
CHAR(n) CHAR(n)
 ? Fixed-length, blank padded string, max size no limit  ? 32767  ?  ? 8000 255  ?  ? about 1 GB  ?  ?

Notes:

Last modified on 17 March 2014, at 19:24