Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Base 'Type formatting' when copying tables

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:

image description

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:

image description

It follows these two dialogs:

image description

image description