OK, thanks, I will keep it text then to be in line with Interbase. So, just to make it clear there is no need for text(5) etc. Just do text without the field size. And I take it the same applies to all other data types?
RBS -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 19 November 2006 23:49 To: sqlite-users@sqlite.org Subject: 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 > READ_CODE text > TERM30 text > TERM60 text); > > Is there any recommended way or does it just not matter? > TEXT, VARCHAR, CHAR, CHARACTER, CLOB, and several other forms all mean exactly the same thing to SQLite. Use whichever seems most meaningful to you. -- D. Richard Hipp <[EMAIL PROTECTED]> ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
