Data type for better performance

Hi all

For better database performance and search, What data type is good for storing phone number – number or text?

And also for currency, should I use currency data type or number.


Thanks in advance

rainbow

For phone number use varchar(14) or varchar(10).
For currency use money or decimal.

thanks Memnoch for reply

thanks again
rainbow

Hi Memnoch,

I forget to mention one thing for phone number I have separate country code, area code and phone number columns.
here what you thing, is it ok to have these columns as varchar or number datatype.

thanks for you time
rainbow

I would store the entire phone number (country code, area code and number) in a single "Phone" field, instead of breaking it up into 3 different fields.

thanks again Memnoch for reply.

rainbow