Need help for the dataype in my table

Hi, I need some help please i am confuse what datatype should i set to my table,if I stored this kind of data


Is it okay to use varchar for this kind of data?

Thank you in advance.

You don’t need to store the % symbol
MySQL? DECIMAL should work

standards-compliant dbms? DECIMAL will work


HI @ Mittineague,@r937,

Thank you for the reply so decimal is the datatype should i use ?

Thank you :slight_smile:


Thank you so much :slight_smile:

you can use “float” for storing the data of such type


FLOAT is an approximate datatype, not useful unless the numbers are extremely small or extremely large, and not the same as DECIMAL