FiveTech Support Forums

FiveWin / Harbour / xBase community
Board indexAll discussionsLogin (GitHub)
Board index FiveWin for Harbour/xHarbour SQLITE MEDIUMBLOB problem
Marc Vanzegbroeck
Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
SQLITE MEDIUMBLOB problem
Posted: Mon Jul 29, 2019 04: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?

Regards,

Marc



FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Marc Vanzegbroeck
Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Re: SQLITE MEDIUMBLOB problem
Posted: Tue Jul 30, 2019 06:10 AM

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?

Regards,

Marc



FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite

Continue the discussion

Static archive · New replies & topics via GitHub Discussions