Hello all,
I have read on the net about types on a field.
In the links table you can add a new field and select 1 of the following type's:
INT, CHAR or TEXT, DATE
My question is:
The CHAR type can only max. 256 characters right ?
TEXT can be as big as it's allowed by the database limits ?
Next question about 'Validation' on a field:
The field ID in links table has Validation ^\d*\.?\d*$
I really don't know what ^\d*\.?\d*$ means.
Does any know a good resources (site) about this sort of things explained ? www.perl.com
Last question is about the Index Weight in the table:
Is this only for the search option? So it index a field when it's >0 and the higher the number (max. 3) the higher it will be listed ? But what if i set index weight to zero, then there will be no search possibility on that field?
Allready thanks.
Regards Startpoint.
I have read on the net about types on a field.
In the links table you can add a new field and select 1 of the following type's:
INT, CHAR or TEXT, DATE
My question is:
The CHAR type can only max. 256 characters right ?
TEXT can be as big as it's allowed by the database limits ?
Next question about 'Validation' on a field:
The field ID in links table has Validation ^\d*\.?\d*$
I really don't know what ^\d*\.?\d*$ means.
Does any know a good resources (site) about this sort of things explained ? www.perl.com
Last question is about the Index Weight in the table:
Is this only for the search option? So it index a field when it's >0 and the higher the number (max. 3) the higher it will be listed ? But what if i set index weight to zero, then there will be no search possibility on that field?
Allready thanks.
Regards Startpoint.
add a new field in database - type question