ANSI SQL 데이터형과 엑세스 DB와 SQL Server의 데이터형 비교표

ANSI SQL 데이터형	Microsoft Access 데이터형	별명	Microsoft SQL Server 데이터형
BIT, BIT VARYING	BINARY	VARBINARY, BINARY VARYING BIT VARYING	BINARY, VARBINARY
미지원	BIT	BOOLEAN, LOGICAL, LOGICAL1, YESNO	BIT
미지원	TINYINT	INTEGER1, BYTE	TINYINT
미지원	COUNTER	AUTOINCREMENT	-
미지원	MONEY	CURRENCY	MONEY
DATE, TIME, TIMESTAMP	DATETIME	DATE, TIME	DATETIME
미지원	UNIQUEIDENTIFIER	GUID	UNIQUEIDENTIFIER
DECIMAL	DECIMAL	NUMERIC, DEC	DECIMAL
REAL	REAL	SINGLE, FLOAT4, IEEESINGLE	REAL
DOUBLE PRECISION, FLOAT	FLOAT	DOUBLE, FLOAT8, IEEEDOUBLE, NUMBER	FLOAT
SMALLINT	SMALLINT	SHORT, INTEGER2	SMALLINT
INTEGER	INTEGER	LONG, INT, INTEGER4	INTEGER
INTERVAL	미지원	-	미지원
미지원	IMAGE	LONGBINARY, GENERAL, OLEOBJECT	IMAGE
미지원	TEXT	LONGTEXT, LONGCHAR, MEMO, NOTE, NTEXT	TEXT
CHARACTER, CHARACTER VARYING, NATIONAL CHARACTER, NATIONAL CHARACTER VARYING	CHAR	TEXT(n), ALPHANUMERIC, CHARACTER, STRING, VARCHAR, CHARACTER VARYING, NCHAR, NATIONAL CHARACTER, NATIONAL CHAR, NATIONAL CHARACTER VARYING, NATIONAL CHAR VARYING	CHAR, VARCHAR, NCHAR, NVARCHAR

[출처]
http://msdn2.microsoft.com/en-us/library/bb177899.aspx

어느 타이밍인가 MEMO 타입와 TEXT 타입의 구분이 없어졌군.