Unanswered: Create constraint on checking column width
We have a problem with a vendor application that creates a lots of issues. The vendor's software is very buggy. When you enter data into a character column that is longer than the width of the column, it accepts the data but then creates other problems that are a lot worse.
I would like to create a constraint on a character field in a table that will check the column width of that particular column and if the entered value is greater than the column width, I would like the constraint to raise an error.
Problem is, I don't have access to the vendor's code, so I don't know if the application would even recognize the error that I would create, but if this could be done, I think it would be worth a test. Or if you have any better ideas on implementing something like this that would be great.
I don't know if this should be a constraint or a trigger or something totattly different.