![How to avoid the error "string or binary data would be truncated" and insert string with truncation in SQL Server? | My Tec Bits How to avoid the error "string or binary data would be truncated" and insert string with truncation in SQL Server? | My Tec Bits](https://www.mytecbits.com/wp-content/uploads/SQL-String-Or-Binary-Data-Would-Be-Truncated-01.png)
How to avoid the error "string or binary data would be truncated" and insert string with truncation in SQL Server? | My Tec Bits
KB275936: “QueryEngine encountered error: FetchScroll…[ODBC SQL Server Wire Protocol driver]String data, right truncated” occurs when executing a report with the datatype NVARCHAR(max) in MicroStrategy Developer 10.x
![22001', u'[22001] [Microsoft][ODBC Driver 17 for SQL Server]String data, right truncation (0) (SQLExecDirectW)') · Issue #396 · mkleehammer/pyodbc · GitHub 22001', u'[22001] [Microsoft][ODBC Driver 17 for SQL Server]String data, right truncation (0) (SQLExecDirectW)') · Issue #396 · mkleehammer/pyodbc · GitHub](https://user-images.githubusercontent.com/3196342/40869574-346dbd82-6650-11e8-8a68-4f19f568727e.png)