CHAR(N), char(n) N is size of string varchar(n), in bytes. CHARACTER(N), nvarchar(n) LVARCHAR(N, Use R) VARCHAR(max) for size greater than 8000 Use NCHAR(N) for multibyte text strings and NVARCHAR(max) for multi-byte text strings with size greater 4000 N is size of string nvarchar(n) in bytes. Use NVARCHAR(max) for size greater than 4000 VARCHAR(N, R), N is maximum CHAR(N), varchar(n) size of string in NCHAR(N) CHARACTER bytes. VARYING(N, R) Use NVARCHAR(M) for multi-byte text strings NVARCHAR(N, nvarchar(n) N is maximum nchar(n) R) size of string in bytes DECIMAL(P, S), decimal(p, s), P is precision, S is None DEC(P, S), scale numeric(p, s) NUMERIC(P, S), MONEY(P, S) INT, INTEGER int, integer None tinyint, smallint, bigint INT8, BIGINT bigint None None DECIMAL(P), float(53), P is precision real, float(n) DEC(P), double NUMERIC(P) precision FLOAT, DOUBLE None real, PRECISION (N) double precision
CHAR(N), CHARACTER(N), LVARCHAR(N, R) char(n) N is size of string in bytes. Use VARCHAR(max) for size greater than 8000 Use NCHAR(N) for multibyte text strings and NVARCHAR(max) for multi-byte text strings with size greater 4000 varchar(n), nvarchar(n) N is size of string in bytes. Use NVARCHAR(max) for size greater than 4000 nvarchar(n) VARCHAR(N, R), CHARACTER VARYING(N, R) varchar(n) N is maximum size of string in bytes. Use NVARCHAR(M) for multi-byte text strings CHAR(N), NCHAR(N) NVARCHAR(N, R) nvarchar(n) N is maximum size of string in bytes nchar(n) DECIMAL(P, S), DEC(P, S), NUMERIC(P, S), MONEY(P, S) decimal(p, s), numeric(p, s) P is precision, S is scale None INT, INTEGER int, integer None tinyint, smallint, bigint INT8, BIGINT bigint None None DECIMAL(P), DEC(P), NUMERIC(P) float(53), double precision P is precision real, float(n) FLOAT, DOUBLE PRECISION (N) double precision None real,