PDA

View Full Version : mySQL datatypes?


g_playa_gent
11-22-2007, 11:09 AM
i have a mysql table with a column that i want to store business numbers,

am using a DECIMAL data type, i want the fields to hold only 11 numbers,

but when i type in the details and submit the data, the numbers appear all jumbled up sittin in the mysql table that i set up...

ive tryed varchar
int, char datatypes but i can get the numbers to appear in the right order...any one out there with ideas help us out please..