SQLITE MEDIUMBLOB problem

[Marc Vanzegbroeck]

Hi,

I'm using MariaDB and SQLite for my programs.
With a setting, I can select the database I want to use.

Now I just notice that I have problems with MEDIUMBLOB-fields in SQLite with more than 250 characters.
Writing to the field is no problem. Checking the data with a SQLite-browse, I can see that the string is OK.
But, when I'm reading a recordset and show the value with oQry:Fields(5):value (in this case the 5th field), the sting is truncked to 255 characters.

I'm using the sqliteodbc.exe driver.
Does anyone else have this problem?

[Marc Vanzegbroeck]

Hi,

It seems to be a Connector problem, because, if I test it with FIVEDBU, I have the same problem.
Does anyone alse use an other connector that can handle bigger BLOB fields?