Re: [sqlite] specifying field type, any benefit?

2006-01-05 Thread shamil_daghestani
To: sqlite-users@sqlite.org <[EMAIL PROTECTED]cc: > Subject: [sqlite] specif

Re: [sqlite] specifying field type, any benefit?

2006-01-04 Thread Mark Wyszomierski
Got it, thank you very much all, Mark On 1/4/06, Henry Miller <[EMAIL PROTECTED]> wrote: > > On Wednesday 04 January 2006 02:54 pm, Mark Wyszomierski wrote: > > Hi all, > > > > I switched to sqlite from mysql awhile ago, I maintained the field types > > in my sqlite implementation such as: > >

Re: [sqlite] specifying field type, any benefit?

2006-01-04 Thread Henry Miller
On Wednesday 04 January 2006 02:54 pm, Mark Wyszomierski wrote: > Hi all, > > I switched to sqlite from mysql awhile ago, I maintained the field types > in my sqlite implementation such as: > > create table students (first_name TEXT, age INTEGER); > > I'm just wondering if there is any point

Re: [sqlite] specifying field type, any benefit?

2006-01-04 Thread drh
Mark Wyszomierski <[EMAIL PROTECTED]> wrote: > Hi all, > > I switched to sqlite from mysql awhile ago, I maintained the field types > in my sqlite implementation such as: > > create table students (first_name TEXT, age INTEGER); > > I'm just wondering if there is any point to specifying the

Re: [sqlite] specifying field type, any benefit?

2006-01-04 Thread Jim C. Nasby
On Wed, Jan 04, 2006 at 03:54:49PM -0500, Mark Wyszomierski wrote: > Hi all, > > I switched to sqlite from mysql awhile ago, I maintained the field types > in my sqlite implementation such as: > > create table students (first_name TEXT, age INTEGER); > > I'm just wondering if there is any

Re: [sqlite] specifying field type, any benefit?

2006-01-04 Thread Kurt Welgehausen
http://www.sqlite.org/datatype3.html

[sqlite] specifying field type, any benefit?

2006-01-04 Thread Mark Wyszomierski
Hi all, I switched to sqlite from mysql awhile ago, I maintained the field types in my sqlite implementation such as: create table students (first_name TEXT, age INTEGER); I'm just wondering if there is any point to specifying the field type as if I try adding a string type into the age