Need help for the dataype in my table

Databases
1

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

20.17%

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

Thank you in advance.

2

You don’t need to store the % symbol
MySQL? DECIMAL should work http://dev.mysql.com/doc/refman/5.0/en/fixed-point-types.html

3

standards-compliant dbms? DECIMAL will work

:slight_smile:

4

HI @ Mittineague,@r937,

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

Thank you :slight_smile:

5

yes

6

Thank you so much :slight_smile:

7

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

8

no

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