Yes, SHORT should translate to Integer.
How about the syntax with create table?
Thanks.

RBS


-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: 19 November 2006 23:45
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Create table / data types

"RB Smissaert" <[EMAIL PROTECTED]> wrote:
> 
> Also, how would I translate these data types of Interbase to SQLite data
> types:
> 
> I take it that it will be like this:
> 
> BLOB      > BLOB
> DATE      > TEXT
> DOUBLE    > REAL
> LONG      > INTEGER
> SHORT     > REAL

Did you mean "SHORT > INTEGER" here?  I don't know what
SHORT means to interbase but I'm guessing that INTEGER
is a closer match.

> TEXT      > TEXT
> VARYING   > TEXT
> 



----------------------------------------------------------------------------
-
To unsubscribe, send email to [EMAIL PROTECTED]
----------------------------------------------------------------------------
-




-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to