Entities - Auto Trim ALL Text Data Types
I would love it if by default all Text based SQL DB Types would just auto trim their content before saving to the BD. I think this could be a very easy add and big win for data cleanliness. I would say there should be like an Entity Attribute you could add to prevent certain field from Trimming. Why? I have no clue personally, but we should have a way to turn it off if needed.
1
Comments
Can I upvote more than once for this feature request? Trimming the text values will help greatly when creating SDOs and exports, without having to remember to rtrim every text field.
That's a great point! Can Aptify ALSO look at updating core product fields created before NVarChar even existed and update them to be NVarChar.
Would also be great if a warning displayed when we try creating a new field and it's char or varchar as I think 90+% of the time we should be using NChar and NVarChar.
Please sign in to leave a comment.