MySQL Forums
Forum List  »  Microsoft Access

Re: Choosing Data Type
Posted by: Roland Bouman
Date: December 23, 2005 07:33AM

1,2) depends what your requirements are. sometimes people use separate fields for region, international and local parts of the phonenumber. I think I'd try using integers, but I'm afraid I do not have much experience with this one. You should definitely check this one out:,37099,37177#msg-37177

This will answer quite a few questions.

3) I'd use a decimal (storing just the numbers, NOT the percent sign).

4) Date is good if you dont need time. It saves storage and can simplify your queries.

Options: ReplyQuote

Written By
November 23, 2005 09:46AM
Re: Choosing Data Type
December 23, 2005 07:33AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.