I am unsure of which data types to use for the following attributes:
A phone number (which is made up of 10 numbers)
A client name
A numeric product ID that acts as a Primary Key
The location/state of the client (which only has 1 out of 8 possible values)
Im not sure of whether to use CHAR or VARCHAR for some of these, or if there is another type I should use.