When I copy a table between two databases (via drag and drop), what is the difference between the similar, optional types, for example between:
Double [DOUBLE]
and Double [DOUBLE PRECISION]
or:
Integer [INT]
and Integer [INTEGER]
???
In my case when moving to a MariaDB connected database it seems that I need to select Double [DOUBLE PRECISION]
, rather than Double [DOUBLE]
, otherwise I get this error:
I suspect this has to do with my target database being connected to MariaDB, but am not sure.
A second question is that even if I select Double [DOUBLE PRECISION]
(and thus don’t get the above error), then once the new table is created it shows up as Double [DOUBLE]
. This seems strange.
A bit of background in case you’re curious: I recently bought a Gamma-Scout geiger counter to monitor any possible future fallout from these two nuclear nut cases (Donald v Kim) who are busy lobbing nuclear threats at each other. The Gamma-Scout can log data every hour (or whatever period I select). I’m testing moving this data to LO Base. So far I’ve got the data across USB and into CSV, and now into Base by connecting with Text/CSV to the directory where I have my CVS file.
But now when dragging and dropping (copying) the table from the initial .odb to a 2nd .odb connected to MariaDB, one of the dialogs I ran into is this one:
It follows these two dialogs: