[Gambas-user] SQLite3 VARYING CHARACTER(255) taken as Boolean?

[Benoît Minisini]

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