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

Character types char.html datatype-character.html 176089 datatype3.html Variable-length with limit VARCHAR(n) VARCHAR(n) VARCHAR(n) VARCHAR(n)NVARCHAR(n) VARCHAR[(n or max)]NVARCHAR[(n or max)] VARCHAR(n) VARCHAR(n)CHARACTER VARYING(n) VARCHAR2(n)VARCHAR(n) is slated for deprecation character varying(n)varchar(n) TEXTuses dynamic typing; allows any type name VARCHAR(n) VARCHAR(n)NVARCHAR(n) Variable-length with limit, max size no limit 65535 about 2 GB about 1 GB 2 GB with (max) or 8000 with the fixed limit 32765 4000 bytes (32767 bytes if MAX_STRING_SIZE = EXTENDED - Oracle 12G) no limit (enforced by global, default = 1M) Fixed-length, blank padded string CHAR(n) CHAR(n) CHAR(n) CHAR(n)NCHAR(n) CHAR(n)NCHAR(n) CHAR(n) CHAR(n) character(n)char(n) CHAR(n) CHAR(n)NCHAR(n) Fixed-length, blank padded string, max size no limit 8000 255 2000 about 1 GB 32767 |} Notes: