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

[Tobias Boege]

On Wed, 07 Aug 2013, Beno?t Minisini wrote:
> 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)"...
> 

I fixed this in #5813.

Regards,
Tobi