On 30/09/2019 22:58, John Cowan wrote:

> I don't, but I found a couple of articles giving the standard data types of
> SQL 2011 and 2016.

Although reading the ANSI SQL specs is instructive, it does include
weird stuff like:

> are portable.  There is a concept of NATIONAL CHAR vs plain CHAR types, but
> it is not even defined whether these are different encodings, never mind
> which encodings they are.

...so it's also good (and a lot more accessible and readable IMHO) to
read the type documentations of real SQL servers that do real work ;-)

MariaDB: https://mariadb.com/kb/en/library/data-types/

PostgreSQL: https://www.postgresql.org/docs/11/datatype.html

Oracle:
https://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#CNCPT012

SQL Server:
https://docs.microsoft.com/en-us/sql/t-sql/data-types/data-types-transact-sql?view=sql-server-2017

--
Alaric Snell-Pym   (M7KIT)
http://www.snell-pym.org.uk/alaric/