SQLITE MEDIUMBLOB problem
Posted: Mon Jul 29, 2019 4:00 pm
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?
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?