Message ''String or Binary Data Would be Truncated'' (Desktop)

Message ''String or Binary Data Would be Truncated'' (Desktop)

The error message "String or Binary Data Would be Truncated" typically occurs when you are trying to insert or update data in a database, and the length of the data being provided exceeds the allowed length for the respective column. In simpler terms, it suggests that you are trying to store a string or binary value that is too long for the designated storage space in the database column.

The message you will see is the following:


If you intend to upgrade to VM PMS Cloud, this message won't be displayed; the system will truncate it to fit the allowed number of characters in the field.

Require assistance with that article?

What is the error? 
What were you doing when this error came up? 
Has anything specific that you noticed that causes this error when you see it? 
Is this happening on all PCs or just one? 
Does this error affect more than one thing in your system? 
Can you provide a screenshot of this error? 
Can you reproduce this error at will? 
Providing responses to the following questions in your ticket could expedite your resolution.

    • Related Articles

    • Reservation (Res) Modification (Mod) Log Report (Desktop) 🎥

      ? Watch Video The Res Modification (Mod) Log allows you to search by date range to see any modifications done on reservations. This can reflect changes done on past date reservations, canceled, and pending reservations. Path: Front Office > ...

    • Delinquent Deposits Report (Desktop) 🎥

      ? Watch Video The Delinquent Deposits report will show any groups that has a past-due deposit. Path: Front Office > Supervisor > Reports > Advance/Delinquent Deposits. Generate report 1. Choose "Delinquent Deposits" from the "Reports" dropdown. 2. ...

    • Setup Data Purge (Desktop)

      Every night, Visual Matrix is purging data that have reached a certain number of days or years. Once data is purged, it cannot be restored. This section is to set up the lenght of time sensitive data is saved before being purged: credit cards, ...

    • Front Office Arrivals Report (Desktop) 🎥

      ? Watch Video The Arrival report shows every arrival for the day, individuals as well as groups. Path: Front Office > Reports > Arrivals. Generate report 1. Narrow down the report using the optional available filters: - by date or period. - by ...

    • Night Audit Credit Card Batch Report (Desktop) 🎥

      ? Watch Video The Credit Card Batch report will show all the credit card transactions posted for the given date and their status (settled or unsettled). Path: Accounting > Night Audit > Reprint Reports > Credit Card Batch. Generate report 1. Click ...