title: Single White space is adding at the end while inserting data into DB?
body: <p>While inserting data into a table using .Net entity framework stored procedure call a white space is appending at the end. this issue is with two columns only.
  where both the columns are having a Foreign Key to different tables (the tables will have allowable values (constants)). 
  FYI.</p>
  
  <ol>
  <li>column 1 is defined as varchar(6) and column 2 is defined varchar (3) in sql DB.</li>
  <li>but the foreign  key table 1 is having data with max length is 4, table 2 is having data with max length is 3.</li>
  <li>in EDMX file below code is available </li>
  </ol>
  
  <p>a) </p>
  
  <pre><code>&lt;Function Name="spInsertdetails" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo"&gt;
          &lt;Parameter Name="column1" Type="char" Mode="In" /&gt;
          &lt;Parameter Name="column2" Type="char" Mode="In" /&gt;
  
  b) &lt;FunctionImport Name="spInsertdetails" ReturnType="Collection(TestDBModel.spInsertdetails_Result)"&gt;
              &lt;Parameter Name="column1" Mode="In" Type="String" /&gt;
              &lt;Parameter Name="column2" Mode="In" Type="String" /&gt;
  </code></pre>
  
  <p>in 3.a) i have tried changing the char to varchar but the issue still present.</p>
  
  <p>Please let me know if any further details required.</p>