I have built a table and one of the fields uses int as the data type.
When I come to write data to it, I get a problem of that I have to many digits for the size of the field.
I am trying to input a IDNumber which has 10 numbers. the wierd thing is that I created the table by taking fields that are already made in other tables and it works ok in there, where could I have gone wrong?
Last edited by JezLisle; 11-07-08 at 10:21.
Reason: Ignore this as me being a dope ;-)
if you're not going to perform math--AVG(IDnumber) perhaps?--then don't use an integer type
...Or treat it as a number for comparisons, or join against another int column, or ...... Strange advice. If it really is a number (as opposed to an account number/serial number etc) then do not treat it as a varchar. That way lies madness.