Custom field max length behaviour in 5.5ce

[jasonj]

Created a custom field in version 5.1 (I think) for the account module.... it is "account abbreviation" a short (less than) 5 character code for an Account .. in 5.1 it would not let you save the record if it was longer than 5 chars, in the upgrade to 5.2 it just saved the first 5 characters..... (which we could live with) ... Now in 5.5 it just doesn't save anything and using the SQL profiler I see that MSSQL has "bombed" the TSQL because "string data would be truncated" so SUGAR is not doing the 5 character limit validation anymore and just trying to pass the whole string ?? Any ideas as to how I get it to do the validation again ???

[Angel]

Are you saying that the field is defined with a length of 5 chars in Sugar, but within the database structure it is shorter, hence the error?

Have you tried to do a repair on the database via the Admin > Repair option in Sugar?