"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] -----------------------------------------------------------------------------
