SQL Field Value is too Long/String or Character would be Truncated

You may receive a String or Character would be truncated or Value too long error if the value you entered into a field is longer than the field accepts.

Both these errors mean that the value you are entering into the field is longer than the field accepts.

For example, the course COCHAR1 field is 15 characters long. In the above images, we tried to enter a value longer than 15 characters.

When you click OK on the error:

• Existing Record - the value will be cleared from the field.
• New Record - the new record will NOT be saved.

If you need to know how many characters a field can hold, go to the Data Structures help topic.