93  SQL Veri Tipleri

93.1 ANSI SQL Veri Tipler

Microsoft tarafından Access için oluşturulmuş aşağıdaki tabloya bakalım. Access (2024)

ANSI SQL data type	Synonym
BIT, BIT VARYING	VARBINARY, BINARY VARYING BIT VARYING
DATE, TIME, TIMESTAMP	DATE, TIME
DECIMAL	NUMERIC, DEC
REAL	SINGLE, FLOAT4, IEEESINGLE
DOUBLE PRECISION, FLOAT	DOUBLE, FLOAT8, IEEEDOUBLE, NUMBER
SMALLINT	SHORT, INTEGER2
INTEGER	LONG, INT, INTEGER4
INTERVAL
CHARACTER, CHARACTER VARYING, NATIONAL CHARACTER, NATIONAL CHARACTER VARYING	TEXT(n), ALPHANUMERIC, CHARACTER, STRING, VARCHAR, CHARACTER VARYING, NCHAR, NATIONAL CHARACTER, NATIONAL CHAR, NATIONAL CHARACTER VARYING, NATIONAL CHAR VARYING

93.2 SQL veri tipleri strings veya varchar

“” ve ’’ tırnak işaretleri arasındaki fark

Access, Microsoft. 2024. “Equivalent ANSI SQL Data Types.” https://support.microsoft.com/en-us/office/equivalent-ansi-sql-data-types-7a0a6bef-ef25-45f9-8a9a-3c5f21b5c65d.