Invalid characters keeps comming and biting me in the ***.
For example the character "Vertical tab" "". (but this is just a new line, so it is ancient technical characters, which is not something most text fields are even desiring) Or any other command characters such as "Backspace".
You can for example not type a "Vertical tab" into a textfield in Google Chrome if you use βAltβ β011β. BUT if you do it in notepad++, and copy the "Vertical tab" and then paste it in the textfield, then tadaaa, you have an undesired character, and this ends up in the database and more complex things then fall apart.
Of course one can try to solve the problem by replacing the undesired characters when needing to work with them as XML etc., but I find this approach somewhat wrong, since I am looking for "User text" and not "ALL possible characters text".
( I am actually coming from a .NET core and MSSQL approach, but I was hoping that an even more generic solution was present, which I was not aware about, maybe wish-full thinking, but one dares to dream :) )
I also tried to copy paste a "Vertical tab" into my outlook application, but here outlook replaces it with a newline, and hence this is not a problem (but using the web outlook will not remove it :S ).
Just for fun, then here is a Vertical tab between the 2 colons:
HereIsAVerticalTab::BetweenThe2Colons
So to sum up the question: What is "best" approach for avoiding such "non user text" characters in a software solution in general?