On Tue, 20 Mar 2007 13:24:17 +0800, you wrote:
>if you create a table use following statement (script generated from MS SQL
>Server 2000)
>CREATE TABLE [XTollData] (
> [DutyID] [char] (32) NOT NULL ,
> [CarNumber] [char] (10) NULL
>);
>
>SQLite3_Column_decltype will treat DutyID as data type 'char' but not
>'char(32)'
I don't think [char] (32) in
[DutyID] [char] (32) NOT NULL ,
is valid SQL. Keywords can be quoted with "" or [] to be able to
use them as identifiers (i.e. objectnames), but IMHO keywords
that have to stay keywords shouldn't be quoted at all.
If you choose your columnnames carefully (not contained in the
collection of reserved words), the [] could easily be filtered
out with sed or awk.
--
( Kees Nuyt
)
c[_]
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
