MySQL Forums
Forum List  »  Delphi

Detecting MEDIUMTEXT vs. VARCHAR in a DBGrid
Posted by: Susan Leigh
Date: November 29, 2006 10:14AM

I'm using Delphi 7, MySQL 5.0, MyODBC connector 3.51 with an ADODataSet component from the ADOnis component suite by Winsoft.

In my program's DBGrid, I want VARCHAR fields to be displayed and edited on the grid, but MEDIUMTEXT fields to be edited in a popup edit window. When connecting to a MS Access or MS SQL database, this was no problem: I could look at TField.DataType and if it was ftMemo, then I knew it was a memo field (the equivalent of MySQL's MEDIUMTEXT) and override the default DBGrid editor with my own popup window. But when connecting to a MySQL database, TField.DataType shows both VARCHAR and MEDIUMTEXT as ftString, so I can't tell the difference. Anyone know how I can distinquish?

Options: ReplyQuote

Written By
Detecting MEDIUMTEXT vs. VARCHAR in a DBGrid
November 29, 2006 10:14AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.