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.

    • Related Articles

    • 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, ...

    • 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. ...

    • 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 ...