From: John Cowan <xxxxxx@ccil.org>
Date: Monday, September 30, 2019 4:58 PM
What are the various levels of Scheme data types we want to support, and how, for databases?
I drew on the R7RS-large docket to populate my Google sheet. I also made sure that it subsumes ISO 11404, a language-independent standard for data types, with the exception of enum types.
Excellent; that was what I was going to start with, and if it's complete for R7RS-large, to the extent we can say that about an unfinished standard ... we need some framework for new Scheme types, or accept sdbi will be superseded at some point. Given that we want to support any relevant odd type a Scheme implementation has added, the former would be best.
What about R6RS?
If anyone has a collection of the last drafts for the latest SQL standards, especially SQL:2016, I would appreciate copies so I don't have to hunt them down on the web.
I don't
but I found a couple of articles giving the standard data types of SQL 2011 and 2016.
[...]
Decimal floats (SQL 2016 only). IEEE, but I have no information on which of 32-bit, 64-bit, and 128-bit formats are supported.
That's the only type I know that was added in SQL:2016. Might be better to search on something like SQL DECFLOAT, e.g. Db2 has some support for them.
- Harold