How do you fix a column out of range value?

To fix the issue, we will have to store a less than 2147483647 or change the data type of student_ssn_no to BIGINT. Let us modify the column to BIGINT and try inserting the data again. As we can see in the above image, student_ssn_no for row 1 got inserted without any error now.

What is out of range value in MySQL?

When MySQL stores a value in a numeric column that is outside the permissible range of the column data type, the result depends on the SQL mode in effect at the time: If strict SQL mode is enabled, MySQL rejects the out-of-range value with an error, and the insert fails, in accordance with the SQL standard.

What is data truncation error in MySQL?

The error can be caused by a data length greater than the maximum size of the field. Using MySQL as an example, a table definition follows: create table person (id int(5), name varchar(5)); The size of the name field is 5.

What is the size of blob in MySQL?

0 to 65535 bytes
BLOB Types

Object type Value length that the object can hold
TINYBLOB from 0 to 255 bytes
BLOB from 0 to 65535 bytes
MEDIUMBLOB from 0 to 16 777 215 bytes
LONGBLOB from 0 to 4 294 967 295 bytes

What is Data truncated for column?

That error means the data is too large for the data type of the MySQL table column.

What is the maximum size for a BLOB?

65535 bytes
A BLOB can be 65535 bytes (64 KB) maximum. If you need more consider using: a MEDIUMBLOB for 16777215 bytes (16 MB) a LONGBLOB for 4294967295 bytes (4 GB).

How do I check my BLOB size?

GetLength – Find the size of BLOB/CLOB column. This is simply how to find the size of individual rows with the CLOB/BLOB column. DBMS_LOB. GetLength returns the number of characters (bytes) in the CLOB/BLOB column.