8152 / 2628 SQL Origin: Data OSI layer 7 · Application Last updated 13 Oct 2026

SQL Server: String or binary data would be truncated in table 'x', column 'y'. (Msg 2628)

A value is longer than the column allows.

Exact message you may see String or binary data would be truncated
Seen on: SQL

Meaning

SQL Server 2019+ (Msg 2628) names the column and value; older versions (Msg 8152) don’t — enable trace flag 460 or compare lengths.

Common causes

  • Input longer than NVARCHAR(n)
  • Column too small for real data
  • Older SQL Server hiding the column name

⚡ Quick fix

  1. Validate lengths
  2. Widen the column
  3. On SQL Server 2016/2017 enable trace flag 460 to see details

Detailed fix by platform

SQL

  1. ALTER TABLE dbo.Visits ALTER COLUMN UserAgent NVARCHAR(512);

How to diagnose

  1. Column — Which one?
  2. Value — Length?

🔧 Still not fixed?

Many errors look alike. If the steps above didn’t solve it, one of these is probably what you’re facing:

Where this error sits

Origin: Data. Errors that are often confused with or caused by this one (click to open):

1406 — MySQL ERROR 1406: Data too long for column (MySQL)140622001 — ERROR: value too long for type character varying(255) (PostgreSQL)22001245 — SQL Server: Conversion failed when converting the varchar value 'x' to data type int. (Msg 245) (SQL)245544 — SQL Server: Cannot insert explicit value for identity column in table 'x' when IDENTITY_INSERT is set to OFF. (SQL)5448115 — SQL Server: Arithmetic overflow error converting expression to data type int. (Msg 8115) (SQL)8115certificate chain not trusted — SQL Server: The certificate chain was issued by an authority that is not trusted. (SQL)certificate chain not…Execution Timeout Expired — SQL Server: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (SQL)Execution Timeout Exp…invalid_type — API Error: Invalid type — expected integer, received string (API)invalid_type8152 / 26…

Explore the map of this error Full error map →

🧠 Still stuck? Analyze your error

Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.

💬 What worked for others

No tips yet — did something else fix this for you?

Share what worked for you

Tips are checked by an editor before they appear. Links are removed.