Column Type using percents

Darren_Evans

Hi all! I'm using a MySql database. What column type do I use to display numbers as percents? I'm trying to build my own project tracker, integrated with a vBulletin userbase. I couldn't get anyone to help me with this, so I'm doing the best I can on my own. 😉

Any help would be appreciated.

mad27

Just use int, and in your query or in your script divide by 100 and add the %-sign.

[deleted]

Q: why on earth would you want to devide by 100?

25% is just '25' plus the % sign.

If you also want to add numers after the decimal point, use a float.