SQL! Truncated string or binary data
compta2
Posted messages
75
Status
Membre
-
Reivax962 Posted messages 3742 Status Membre -
Reivax962 Posted messages 3742 Status Membre -
Hello,
I am using an ERP software suite Sage 100 Enterprise V16.01 with SQL Server 2008, everything works very well except for the accounting of invoices under commercial management which has the following errors:
- the string or binary data will be truncated
- the statement has been stopped
- SQL Error!
your help on the source of these problems and the resolutions is greatly appreciated!!!
Thank you in advance
Configuration: Server: HP Proliant DL 380 - Intel Xeon L5520 - RAM 8 GB - HDD: 300 GB - Win Server 2003 - SQL Management Studio 2008
I am using an ERP software suite Sage 100 Enterprise V16.01 with SQL Server 2008, everything works very well except for the accounting of invoices under commercial management which has the following errors:
- the string or binary data will be truncated
- the statement has been stopped
- SQL Error!
your help on the source of these problems and the resolutions is greatly appreciated!!!
Thank you in advance
Configuration: Server: HP Proliant DL 380 - Intel Xeon L5520 - RAM 8 GB - HDD: 300 GB - Win Server 2003 - SQL Management Studio 2008
3 réponses
Hello,
This kind of problem occurs when a string (or a binary string) is inserted into a column whose type does not allow for that much data to be stored.
For example, if we try to insert "YOUPI" into a column of type CHAR(4), the data will be truncated and we will end up with only "YOUP".
However, it will be difficult to say more without access to the system...
Xavier
This kind of problem occurs when a string (or a binary string) is inserted into a column whose type does not allow for that much data to be stored.
For example, if we try to insert "YOUPI" into a column of type CHAR(4), the data will be truncated and we will end up with only "YOUP".
However, it will be difficult to say more without access to the system...
Xavier
