How to fix CR_DATA_TRUNCATED (2032): Data truncated in MySQL

DESCRIBE your_table_name;
-- or
SHOW CREATE TABLE your_table_name;

SET sql_mode = 'STRICT_TRANS_TABLES';

-- Increase VARCHAR length
ALTER TABLE your_table MODIFY column_name VARCHAR(255);

-- Change TEXT to MEDIUMTEXT (up to 16MB)
ALTER TABLE your_table MODIFY column_name MEDIUMTEXT;

-- Change to LONGTEXT (up to 4GB)
ALTER TABLE your_table MODIFY column_name LONGTEXT;

-- Increase numeric precision
ALTER TABLE your_table MODIFY price_column DECIMAL(10,2);

// JavaScript/Node.js example
const maxLength = 100;
const trimmedValue = longString.substring(0, maxLength);

// Or validate before insert
if (value.length > maxLength) {
  throw new Error(`Value exceeds maximum length of ${maxLength}`);
}

# Python example
max_length = 100
trimmed_value = long_string[:max_length]

# Validate
if len(value) > max_length:
    raise ValueError(f"Value exceeds maximum length of {max_length}")

// Check for truncation after fetch
int status = mysql_stmt_fetch(stmt);
if (status == MYSQL_DATA_TRUNCATED) {
  // Check which columns were truncated
  for (int i = 0; i < field_count; i++) {
    if (bind[i].error) {
      // Reallocate buffer and refetch
      // Or handle the truncation appropriately
    }
  }
}

bool report = false;
mysql_options(mysql, MYSQL_REPORT_DATA_TRUNCATION, &report);

-- Instead of inserting empty strings
INSERT INTO table (column) VALUES ('');

-- Use NULL for nullable columns
INSERT INTO table (column) VALUES (NULL);

-- Or omit the column in INSERT
INSERT INTO table (other_column) VALUES ('value');