---
title: "String or binary data would be truncated"
description: "String or binary data would be truncated"
keywords: "String or binary data would be truncated NAV SQL Error message"
url: "https://myrapidi.com/wiki/string_or_binary_data_would_be_truncated"
locale: "en"
published: "2025-01-13T12:54:55Z"
modified: "2025-01-13T16:05:22Z"
---

**Scenario** : Triggered when trying to insert or update a value that exceeds the maximum allowed size for a column.  
  
**Error Message** : `String or binary data would be truncated in table 'Customers', column 'Name'.`  
  
**Cause** : Data from the source system has fields longer than defined in the NAV database schema.  
  
**Resolution** :

1. Use `INFORMATION_SCHEMA.COLUMNS` to check column sizes.
2. Truncate or clean the source data to fit the column limits either directly into your system or by using our formulas such as ##COPY.