Recently in do with Unidac, a program used to read the android contact2. The db files, contact the pictures which need to extract, contact the pictures stored in the data table of data15 field, the field type is Text types, I used the Unidac query component query, query to only 4 bytes, money use SQLIte Expert software binary content editor view field, found that there is no problem, but a 00 bytes after the 4 bytes, I suspect that may be found in the foreground of the query time because the 00 byte led to the suspension of Unidac subsequent data read,

So to ask you, how to avoid to solve?

I had thought in SQL join field type conversion code, but check the information not found similar MSSQL conver function

Also had thought in Delphi to adjust uniquery field type, but also no use...

Help!!!!!!!!!!!

CodePudding user response:

Use m_qry. FieldByName (' data15.) try AsBytes