I have field name "Category" and its is number data type. Why I cannot store zero value in the table, I want to store the value like this 0001 but it store the value in the "category" field as '1' .Why?
Printable View
I have field name "Category" and its is number data type. Why I cannot store zero value in the table, I want to store the value like this 0001 but it store the value in the "category" field as '1' .Why?
0001 is a text field - we would store that as VARCHAR(4).
Leading 0's are not supported in a numeric type of field - those fields store numbers and leading 0's, being not significant, are simply discarded.
In other words, if you want the leading zero's change the field type from number to text, otherwise, those zeros will continue to be dropped.