title: A sequence of whitespace added to the end of CHAR columns
body: <p>Today I ran into a weird problem. I have a database in SQL Server which is filled with Linq data access layer. Now I've got some columns that are of datatype <code>CHAR(100)</code> for example . </p>
  
  <p>When I`m inserting everything seems to be working fine but when I retrieve these values there some sequence of whitespace has been added to the end of each value.</p>
  
  <p>Anyone got an idea? </p>