Recent

Author Topic: Why do text fields and tinytextfields show as (blob)?  (Read 5393 times)

Lundstudio

  • Newbie
  • Posts: 2
Why do text fields and tinytextfields show as (blob)?
« on: May 09, 2008, 10:08:48 am »
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

  • New Member
  • *
  • Posts: 13
Re: Why do text fields and tinytextfields show as (blob)?
« Reply #1 on: November 24, 2010, 05:05:52 pm »
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

  • Guest
Re: Why do text fields and tinytextfields show as (blob)?
« Reply #2 on: November 25, 2010, 05:18:10 am »
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

 

TinyPortal © 2005-2018