[Gambas-user] SQLite3 VARYING CHARACTER(255) taken as Boolean?
Benoît Minisini
gambas at ...1...
Wed Aug 7 00:36:54 CEST 2013
Le 05/08/2013 16:22, Tobias Boege a écrit :
> Hi,
>
> we have a case at http://gambas-club.de where one uses an SQLite3 database
> with some fields being of type VARYING CHARACTER(255). These are all shown
> to be Booleans by Gambas code. Note that the TEXT type apparently is handled
> correctly.
>
> I have absolutely no idea of the Gambas DBMS drivers, therefore seek an
> explanation (or fix).
>
> Minimal project and the database attached.
>
> Regards,
> Tobi
>
The Gambas <-> Database datatype mapping is detailed there:
http://gambasdoc.org/help/doc/db-type-mapping?v3
But SQLite is special as the field datatype has no real meaning for it
(every field can store anything), it is just a string description.
(Actually it is not 100% true, look in the SQLite documentation).
I will look at the Gambas sqlite drivers to see how they interpret
"VARYING CHARACTER(255)"...
--
Benoît Minisini
More information about the User
mailing list