Why do text fields and tinytextfields show as (blob)?
lazarus / 16-Databases

----------------------------------------------------------------------
Lundstudio · 2008-05-09 08:08

I am using TMySQL50Connection to a MySQL5 database and the connection
works, the query and the transaction also works but I can't see the
contents of the text fields in my DBGrid. They all show as (blob). Do
I need to make a conversion, if so, where and how? The fields are not
blob fields in MySql but text fields, and tinytext fields. What is
wrong?

----------------------------------------------------------------------
kellemes · 2010-11-24 16:05

My apologies for responding to this old thread but I' m just starting
with lazarus and have the exact same issue..
The only difference is I'm connecting to a sqlite db.
Indeed, all db-components show fields of type TEXT as blob.. why is
that?

----------------------------------------------------------------------
Lacak2 · 2010-11-25 04:18

For SQLite (sqlDB components):
 TEXT fields are mapped to ftMemo fields, so in DBGrid should be
(memo) or (MEMO), not (blob) or (BLOB)

For MySQL (sqlDB components):
 TEXT and BLOB fields are not distinguished correctly, so both are
treated as BLOB