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
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
[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
[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
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
[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
<[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
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)'
8 matches
Mail list logo