[Gambas-user] Databases, please help me!

[Dag Jarle Johansen]

Hi,

a BLOB is defined as a field for binary data, which only means, every
character is stored as is, this may be letters or the codes you get from
an image. So far clear. In MySQL one has to increase the
max_allowed_packet, because by default max. 1MB can be written in one
line (field). looking for SQLite .... 

you can see some declarations and examples here:
http://www.sqlite.org/datatype3.html
and as I understand it, you may select BLOB as well. 

As you get a result in your editor, I asume you have configured SQLite
correctly. Try out some simple select first, and look if you get any
results, so you can analyze where you get the wrong result.

Regards,
Dag




Am Samstag, den 06.02.2010, 23:25 +0100 schrieb M. Cs.:

> This error was just typographic. Of course I was using SELECT in the
> program.
> But letting out the semicolon doesn't changes the situation.
> Is it possible, that SELECT cannot handle records which are containing
> BLOBS?
> ------------------------------------------------------------------------------
> The Planet: dedicated and managed hosting, cloud storage, colocation
> Stay online with enterprise data centers and the best network in the business
> Choose flexible plans and management services without long-term contracts
> Personal 24x7 support from experience hosting pros just a phone call away.
> http://p.sf.net/sfu/theplanet-com
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user