INT in db not showing correctly

[nickbunyun]

i have made a field for phone numbers..

and when i type them in.. even tho i tried different phone numbers such as 8741234567 or 7704551234

it shows up like this in the database

2147483647 

riu 2147483647

rds 2147483647

esting 2 2147483647

llards2 2147483647

ikless 2147483647

 

 

phonenr field infos

 

int(10)

Null=no

[The Little Guy]

try changing it to varchar(10)

[Daniel0]

It's too large for a signed integer. It cannot be higher than 2,147,483,647 for signed integers and 4,294,967,295 for unsigned integers. Try bigint instead.

[nickbunyun]

thanks..

i changed it to varchar and it works wonderful!

 

thanks