Re: [sqlite] About field sizes...

[Kurt Welgehausen]

> What effect has dimension on field size? ...

See 
and .

The dimension(s) has no effect on the actual storage.

> And why is it valid when you mention "date" ... ?

The type in a create statement serves only to determine
the type affinity for the column. Specified type can be
anything. If 'date' is specified for the type, the
column will have type affinity 'numeric'. See the files
mentioned above.

Regards

Re: [sqlite] About field sizes...

[Clay Dowling]

Igor Gorbounov said:
> I've seen in some sources that folks write something like this:
> create table MyTable(
>event varchar(200),
>event_date date);
>
> What effect has dimension on field size? The syntax reference mentions
> some "number"
> near field type, but it is not explained what this number is for.
> And why is it valid when you mention "date" as a field type?
> Igor Gorbounov

In a database that was more rigid about field typing the number would
indicate the maximum number of charactes allowed in that field.  For
SQLite programmer's that size is a combination of habit and reference.  By
looking at the number in the schema I have a reminder for how large I
intend to make that field in my program.

Clay Dowling
-- 
Lazarus Notes from Lazarus Internet Development
http://www.lazarusid.com/notes/
Articles, Reviews and Commentary on web development

[sqlite] About field sizes...

[Igor Gorbounov]

I've seen in some sources that folks write something like this:
   create table MyTable(
  event varchar(200),
  event_date date);
What effect has dimension on field size? The syntax reference mentions 
some "number"
near field type, but it is not explained what this number is for.
And why is it valid when you mention "date" as a field type?
   Igor Gorbounov