• From: Netherlands
  • Registered: 2014-07-10
  • Posts: 8

Topic: Field types

I have noticed that SQliteStudio reports some different field types than MVDB.
Tekst, Integer and Real are reported the same.

MVDB-Bolean      is reported as Integer.
MVDB-DateTime  is reported as Tekst.
MVDB-Date          is reported as Tekst.
MVDB-Time         is reported as Tekst.
MVDB-Image       is reported as Blob. This is OK I think.
MVDB-File           is reported as Blob. This is OK I think.

Why does MVDB has many different field-type options, when actually most field are Tekst-type ?
Can these differences be a problem ?

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Field types

Here you can get some info about it:
http://sqlite.org/datatype3.html


I created these types for easier understanding.

Dmitry.