RE: [sqlite] Create table / data types

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 Smis

Re: [sqlite] Create table / data types

"RB Smissaert" <[EMAIL PROTECTED]> wrote: > I can see that doing this: > > create table ReadCode > (SUBJECT_TYPE varchar > READ_CODE varchar > TERM30 varchar > TERM60 varchar); > > Seems to work just the same as does this: > > create table ReadCode > (SUBJECT_TYPE text >

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 >

RE: [sqlite] Create table / data types

I can see that doing this: create table ReadCode (SUBJECT_TYPE varchar READ_CODE varchar TERM30 varchar TERM60 varchar); Seems to work just the same as does this: create table ReadCode (SUBJECT_TYPE text READ_CODE text TERM30 text TERM60 text);