Android Question dbutils - ExecuteMap Cannot convert Blob to String

RVP

Active Member
Licensed User
I am getting this error when I try to read a record from an SQLLIte database that has a BLOB field defined

I currently am forcing it to work by doing:

B4X:
Try
            res.Put(cur.GetColumnName(i).ToLowerCase, cur.GetString2(i))
        Catch
            Dim  byt() As Byte: byt  = cur.GetBlob2(i)
            res.Put(cur.GetColumnName(i).ToLowerCase, BytesToString(byt,0,byt.Length,"UTF8"))
        End Try

But I would rather make it more proactive, and only use this code if the column is actually a type of Blob
Is there anyway to tell this? Cursor does not seem to have the info on column types
 
Top