Data type

  • Thread starter Thread starter bbawa1
  • Start date Start date
B

bbawa1

Hi,

I have text boxes in my web form. I am typing phone number
1-769-876-2345. and try to insert this data in a column named
Cellphone which is of data type numeric(18,0). But it is giving me
error that string is not in proper format. So it is not inserting
data in datadase. What should be the datatype of this column will be.

Thanks
 
Hello,

1-769-876-2345 would be considered to be a variable length of characters (it
indeed is a string), so that might indicate that proper datatype is perhaps
varchar(18), if you expect that 18 is the maximum length of string to be
inserted
 
Back
Top