Re: [sqlite] data type problem

2007-03-22 Thread qinligeng
07 4:55 AM Subject: Re: [sqlite] data type problem > 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] [c

Re: [sqlite] data type problem

2007-03-22 Thread Kees Nuyt
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

Re: [sqlite] data type problem

2007-03-21 Thread Dennis Cote
[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

Re: [sqlite] data type problem

2007-03-21 Thread Dennis Cote
[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

Re: [sqlite] data type problem

2007-03-21 Thread qinligeng
From: <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Tuesday, March 20, 2007 7:48 PM Subject: Re: [sqlite] data type problem <[EMAIL PROTECTED]> wrote: > if you create a table use following statement (script generated from MS SQL > Server 2000) > CREATE TABLE

Re: [sqlite] data type problem

2007-03-20 Thread Dennis Cote
[EMAIL PROTECTED] wrote: <[EMAIL PROTECTED]> 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

Re: [sqlite] data type problem

2007-03-20 Thread drh
<[EMAIL PROTECTED]> 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

[sqlite] data type problem

2007-03-19 Thread qinligeng
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)'