CODEWITHSUNDEEP
mysqlvarchar
Chris Zammit
Chris Zammit

Reputation: 43

Varchar issue on Mysql 2147483647

Having the 2147483647 MYSQL issue.

When inserting an 11 digit number in the telephone field i am getting this number in return saved in the DB: 2147483647

TEL is set as VARCHAR not INT tough.

Also, on a database hosted on SERVER 1 i have the same exact database table and not having the same issue tough?! what might be?

This is the SQL and PHP

tel_no  varchar(20) utf8_general_ci  Yes    NULL
mob_no  varchar(20) utf8_general_ci  Yes    NULL

That's the MYSQL. Yes i am inserting an 11 digit number as string in the DB 

$telno = GetValue($post['tel_no']);
$mobno = GetValue($post['mob_no']); 

$sql = "UPDATE ".$this->dbpre."bookings SET tel_no='$telno', mob_no='$mobno'...

Can you please help? I am getting crazy!

Upvotes: 3

Views: 4557

Answers (3)

lalna s m
lalna s m

Reputation: 11

solution : just change the type from int to bigint or varchar to bigint.

Upvotes: -1

Eugine Joseph
Eugine Joseph

Reputation: 1558

Check Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT and answer

Upvotes: 0

George
George

Reputation: 6084

2147483647 is the largest int value for mysql. Just change the type from int to bigint.

Upvotes: 5

Related Questions