A brief history: There used to be a size limitation in dBase and perhaps Paradox. Traditionally this was supported within the Borland Database Engine. In the Delphi components this resolved in text fields and memo fields. The Borland Database Engine (BDE) and the components within Delphi. From this size limit (probably 255 characters) the field types are set into the component layer.
I've written a dbExpress driver for Delphi 6, and working a version for DbExpress4 (Delphi 2007) which has a preference which can be set. Using this preference you are allows to implement longer texts as memo's or keep them as strings. Either way the application needs to know when to switch display behaviour. Some programming needs may still be required. It may be that SQLite's BLOB support may be a better way to solve this in the end. I haven't really looked at that yet. In any case it is the Connector or Driver on top of SQLite which determines the actual field type into the component layer of Delphi. This is what the DbExpress driver is supposed to do, translate the database specifics into Delphi specifics (and back). Regards, Marco. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
