100 Database Data Types

100 Common Data Types

Database data types define the kind of values that can be stored in a particular column of a database table. Different database systems support various data types, each designed to accommodate specific types of information. Understanding and using the appropriate data types is crucial for efficient storage, accurate querying, and maintaining data integrity. Here are some common database data types.

Numeric Data Types:

  1. INT
  2. TINYINT
  3. SMALLINT
  4. MEDIUMINT
  5. BIGINT
  6. DECIMAL
  7. NUMERIC
  8. FLOAT
  9. DOUBLE
  10. REAL
  11. BIT
  12. BOOLEAN

Character String Data Types: 13. CHAR

  1. VARCHAR
  2. TEXT
  3. BLOB
  4. MEDIUMTEXT
  5. MEDIUMBLOB
  6. LONGTEXT
  7. LONGBLOB

Date and Time Data Types: 21. DATE

  1. TIME
  2. DATETIME
  3. TIMESTAMP
  4. YEAR

Boolean Data Type: 26. BOOL

  1. BOOLEAN

Binary Data Types: 28. BINARY

  1. VARBINARY

Enumerated and Set Data Types: 30. ENUM

  1. SET

Spatial Data Types: 32. GEOMETRY

  1. POINT
  2. LINESTRING
  3. POLYGON
  4. MULTIPOINT
  5. MULTILINESTRING
  6. MULTIPOLYGON
  7. GEOMETRYCOLLECTION

JSON and XML Data Types: 40. JSON

  1. XML

Array Data Types: 42. ARRAY

UUID Data Type: 43. UUID

Other Specialized Data Types: 44. MONEY

  1. CIDR
  2. INET
  3. MACADDR
  4. TSVECTOR
  5. TSQUERY

Serial Data Types: 50. SERIAL

  1. BIGSERIAL
  2. SMALLSERIAL

Interval Data Type: 53. INTERVAL

Composite Data Type: 54. RECORD

Pseudo-Data Types: 55. ANY

  1. VOID

Domain Data Type: 57. DOMAIN

Row Data Type: 58. ROW

Internal Data Type: 59. INTERNAL

Network Address Data Types: 60. IPADDRESS

  1. MACADDR8

Text Search Data Types: 62. TSVECTOR

  1. TSQUERY

Geometric Data Types: 64. BOX

  1. CIRCLE
  2. LINE
  3. LSEG
  4. PATH
  5. POINT
  6. POLYGON

HSTORE Data Type: 71. HSTORE

Bit String Data Types: 72. BIT VARYING

  1. BIT

Character Large Object Data Types: 74. CHARACTER LARGE OBJECT (CLOB)

Binary Large Object Data Types: 75. BINARY LARGE OBJECT (BLOB)

National Character String Data Types: 76. NATIONAL CHARACTER

  1. NATIONAL CHARACTER VARYING
  2. NATIONAL CHARACTER LARGE OBJECT (NCLOB)

Cursor Data Type: 79. CURSOR

User-Defined Data Types: 80. DOMAIN

External Data Representation Data Types: 81. SQL_JSON

  1. SQL_BINARY
  2. SQL_VARBINARY
  3. SQL_LONGVARBINARY
  4. SQL_DATE
  5. SQL_TIME
  6. SQL_TIMESTAMP
  7. SQL_NUMERIC
  8. SQL_DECIMAL
  9. SQL_BIT
  10. SQL_TINYINT
  11. SQL_SMALLINT
  12. SQL_INTEGER
  13. SQL_BIGINT
  14. SQL_FLOAT
  15. SQL_REAL
  16. SQL_DOUBLE
  17. SQL_BINARY
  18. SQL_CHAR
  19. SQL_VARCHAR

These are just a selection of the various data types available in database management systems. Depending on the specific database system you’re using, some of these data types might not be available or might be named slightly differently. It’s important to consult the documentation of your chosen database system for a complete and accurate list of supported data types.