[EMAIL PROTECTED] wrote: > but if you create a table using: > > CREATE TABLE XTollData ( > DutyID char (32) NOT NULL , > CarNumber char (10) NULL > ); > > SQLite3_Column_decltype will return the result of 'DutyID' as 'char(32)'. > That is, SQLite3_Column_decltype treat '[char](32)' as 'char', treat > 'char(32)' as 'char(32)'. > I think this IS a bug. > A Delphi compoenent(ASGSQLite3) use SQLite3_Column_decltype to determine the > data type and data size of a field. And this "feature" makes it get the wrong > size of '[char](32)' (as 1 byte), and get the right size of 'char(32)' (as 32 > bytes). > > I agree that what you have found is a bug, and you should report it by clicking the bugs link at http://www.sqlite.org/.
In the mean time there is a workaround, and that is to eliminate the unnecessary square bracket quoting on your column type names (i.e. use char and not [char]). Dennis Cote ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
