Results 1 to 2 of 2
Jun 4, 2007, 11:54 #1
- Join Date
- Sep 2005
- 0 Post(s)
- 0 Thread(s)
Advice on Setting up Address Database Please
(Before i start i feel obliged to point out my Noobie status so not to shock! )
As part of a larger poject i need to set up an name and address database.
Before i start i would very much appreciate some comments on the format of the primarry tables.
For example if i set first_name as VARCHAR(15), last_name VARCHAR(30) - this seems ok, but from experience what would people suggest as being realistic for the Address part..
Do i need several fields to allow for each line of the address:
MyCounty / State
I have found several different stratergies for this such as VARCHAR with no max length.... is this a good idea?
Aslo UK post codes - i guess a VARCHAR of max 10 would suffice, but does any one know of an imput mask / regular expression to ensure valid imput?
Any thoughts or directions to a good tutorual would be most greatfull.
Jun 4, 2007, 17:55 #2
- Join Date
- Jul 2002
- Toronto, Canada
- 52 Post(s)
- 2 Thread(s)
VARCHAR must have a length, and i would use something large enough to hold whatever is reasonable
i have known people whose surname is longer than 30 characters -- why not use 50, or even 100? it's not as if there will be any space wasted