Hi Mariano
> INSERT INTO test_large_columns (large_clob, large_blob)
> VALUES ("large_clob_data", "large_blob_data")
>
> Both, the creation and the insert work ok. The problem is the query.
> Actually, the problem is that if I call odbx_column_type() for the column
> called "large_blob" which is the BLOB, I get that the type is *16r20 (32
> in decimal), which is the code of the CLOB, NOT THE BLOB. *
Could you try the following statement?
INSERT INTO test_large_columns (large_clob, large_blob)
VALUES ('large_clob_data', x'large_blob_data')
Note the single quotes for the values and the "x" before the BLOB value.
Please try also without the "x" if there's a difference.
SQLite doesn't always behave like other databases. Please have a look at
http://www.sqlite.org/datatype3.html
Norbert
--
OpenPGP public key
http://www.linuxnetworks.de/norbert.pubkey.asc
signature.asc
Description: This is a digitally signed message part.
------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev
_______________________________________________ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
