The title pretty much says it all.
I see a list of field types (Text [ VARCHAR], Tiny Integer [ TINYINT }, etc.) in the Field Type pulldown but where are their characteristics documented?
A corollary question: is it possible to create a column that can only contain specific, enumerated values? What would be called an enum in C and similar programming languages?
Thanks,
Charles
Partly that is an elementary feature of relational databases:
You column will contain a foreign key wich relates bto another table with your specific values. The relation enforces the range given by the available values in the other column.
.
Above model works for cases, where you can have only single attributes, like selecting a car in blach, white, red, green. If more than one attribute is possible (m:n relation) you would need a separate table to store the relation.
The relevant documentation of HSQL 1.8 on one page: Chapter 9. SQL Syntax
and may be the chapter on text tables: Chapter 6. Text Tables
HyperSQL supports all the types defined by SQL-92, plus BOOLEAN, BINARY, ARRAY and LOB types that were later added to the SQL Standard. It also supports the non-standard OTHER type to store serializable Java objects.
…
It also conforms to any additional integrity constraints that are defined as CHECK constraints
Thanks.
Is there any cross-reference from the LO doc such that a newbie user such as myself would know to look there?
I’d say no. My point if view is: Base can connect to different databases and it is not even necessary for Base to know them, if you connect through ODBC- or JDBC-drivers. So I decide wich database to use, and I have to find my documentation.
.
Its true, it would be nice to have good docs on the HSQLDB, as it is the default database, but on the other hand I’d think it is a waste of time to repeat the documetation of HSQLDB on the LibreOffice-side.
.
Btw: You know the “guide” for Base from the documentation of LibreOffice:
https://documentation.libreoffice.org/en/english-documentation/
from Database Selection
…
Create a new database
Select to create a new database. This option uses the HSQL database engine with default settings. The final page of the wizard appears next.
External web page about HSQL.
And that link leads to the current version 2.7 of HSQLDB/ HyperSQL, while the embedded databases are still at 1.8. So this link may lead to features not available in Base.
.
(And I understand cross-reference as being more than a simple link to the HSQLDB-site, but maybe I’m wrong there. I’m no native speaker.)
Yes. Read much of it before posting.
CM
That is the answer, really. I did not realize that a “comparison” would be the basic documentation.