does lazarus support sqlite byte field? lazarus / 13-General ---------------------------------------------------------------------- creatxr · 2010-06-08 07:21 does lazarus support sqlite byte field? message: "unkown record type:xxx" ---------------------------------------------------------------------- stonefull · 2010-06-08 08:30 Please, read this document about sqlite datatype: http://www.sqlite.org/datatype3.html ---------------------------------------------------------------------- creatxr · 2010-06-08 19:29 i use the firefox extension SQLite manager to create my sqlite database. create table x( ... bytefield byte, ... ); it's well with SQLite manager. but it has problem with lazarus ---------------------------------------------------------------------- garlar27 · 2010-06-09 04:45 According to SQLite documentation "any unrecognized field type will be treated as text...". when I tried to use TSQLite3Table I had problems showing my table on a DBGrid because all the columns or at least most of them where displayed as 255 chars wide in display with  ... to fix that I tried the following: No more TSQLite3Table ... instead ZEOS DBO (TZTable & TZConnection); I also changed the Table deffinition to something ... "more standard SQL "  ... and it worked. Nevertheless there where some fieldtypes that caused problems (specially some MS-SQL types). But with a small change it finally worked  . Probably your SQLite Manager understands the "BYTE" type deffinition and the component you are using don't.