Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

add a new field in database - type question

Quote Reply
add a new field in database - type question
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 Smile

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.

Subject Author Views Date
Thread add a new field in database - type question startpoint 2568 Aug 20, 2000, 9:31 AM
Thread Re: add a new field in database - type question
Stealth 2518 Aug 20, 2000, 10:20 AM
Thread Re: add a new field in database - type question
startpoint 2541 Aug 20, 2000, 11:46 AM
Thread Re: add a new field in database - type question
Stealth 2521 Aug 20, 2000, 4:14 PM
Thread Re: add a new field in database - type question
startpoint 2475 Aug 21, 2000, 4:46 PM
Thread Re: add a new field in database - type question
Stealth 2478 Aug 21, 2000, 5:13 PM
Thread Re: add a new field in database - type question
startpoint 2466 Aug 22, 2000, 11:27 AM
Thread Re: add a new field in database - type question
Stealth 2482 Aug 22, 2000, 11:30 AM
Thread Re: add a new field in database - type question
startpoint 2459 Aug 22, 2000, 11:55 AM
Post Re: add a new field in database - type question
startpoint 2455 Aug 22, 2000, 12:05 PM