MySQL too long varchar truncation/error setting

by

You can disable STRICT_TRANS_TABLES and STRICT_ALL_TABLES. This allows the automatic truncation of the inserted string.

Quote from MySQL Documentation.

Strict mode controls how MySQL handles invalid or missing values in
data-change statements such as INSERT or UPDATE. A value can be
invalid for several reasons. For example, it might have the wrong data
type for the column, or it might be out of range. A value is missing
when a new row to be inserted does not contain a value for a non-NULL
column that has no explicit DEFAULT clause in its definition. (For a
NULL column, NULL is inserted if the value is missing.)

Reference: MySQL Server SQL Modes

More Related Contents:

  1. MySQL Error #1071 – Specified key was too long; max key length is 767 bytes
  2. MySQL: Large VARCHAR vs. TEXT?
  3. What is the MySQL VARCHAR max size?
  4. Equivalent of varchar(max) in MySQL?
  5. Difference between VARCHAR and TEXT in MySQL [duplicate]
  6. MySQL VARCHAR Lengths and UTF-8
  7. MySQL varchar index length
  8. SQL unique varchar case sensitivity question
  9. What to do when you need integers larger than 20 digits on mysql?
  10. What are the optimum varchar sizes for MySQL?
  11. INSERT INTO SELECT statement with more columns which is not in another table
  12. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  13. Why does MYSQL higher LIMIT offset slow the query down?
  14. Normalization in MYSQL
  15. MySQL load NULL values from CSV data
  16. Is there a REAL performance difference between INT and VARCHAR primary keys?
  17. JOIN queries vs multiple queries
  18. Getting around MySQL “Can’t reopen table” error
  19. SQLException: No suitable driver found [duplicate]
  20. In MySQL, can I copy one row to insert into the same table?
  21. MySQL: Cloning a MySQL database on the same MySql instance
  22. “where 1=1” statement [duplicate]
  23. MySQL Calculate Percentage
  24. How to insert selected columns from a CSV file to a MySQL database using LOAD DATA INFILE
  25. My SQL Dynamic query execute and get ouput into a variable in stored procedure
  26. Postgres LEFT JOIN with WHERE condition
  27. MySQL – Using COUNT(*) in the WHERE clause
  28. Duplicate entry for key ‘group_key’
  29. How can I rebuild indexes and update stats in MySQL innoDB?
  30. mysql – move rows from one table to another

Leave a Comment