Search notes:

SQL: data types

Collections

Hierarchy

The image was produced with graphviz/dot and this file.

Predefined types

The standard lists the following predefined types:

Composite types

The constructed (composite) data types can be created with one of the constructors
  • ARRAY
  • MULTISET
  • REF
  • ROW
Arrays and Multisets are also referred to as collecion types.

User defined types

A user defined type is a schema object.

See also

The special null value that is used for absent data.
A feature of SQLite is that it is not necessary to specify a data type when a table is created.
SQLite supports data types: integer, real, text, null and blob.
SQL Standard feature F382: alter column … <datatype>
Array types: feature S091
DECFLOAT data type: feature ID T076 (Optional feature with SQL:2016)
SQLite supports five data types: integer, real, text, null and blob.
Data types in SQL Server

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1747374165, '18.119.139.22', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/SQL/data-types/index(94): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78