I am developing a vb.net winform project that uses a sql server database to take in details of a person (e.g. name, contact number, address). I have set the length of each field in the database and on each textbox, e.g. email is set to 150 characters long. The problem is when I query the database to show a particular persons details, I noticed that there is a lot of white spaces at the end of each field coming back from the database e.g. if the email is 20 characters long there are 130 white spaces at the end of it. This is a problem because I have regex expressions to validate the email and contact number, that are returning false because of the white spaces at the end of each field. What can I do to solve this problem? Thanks in advance for your help.
Submit an article or tip