title: SQL Server Truncation Error when column length should be sufficient
body: <p>I have a table in SQL Server 2008
  <br/>
  Table Name : tbl_device <br/>
  Table Structure:
  <br/></p>
  
  <pre>
  Column  | Type
  col1    | nvarchar(200)
  </pre>
  
  <p>Now when i try to insert data into this (it works for shorter cases but) and the string data is long i.e. with 
  LEN function it is 162</p>
  
  <p>Still the server gives error :</p>
  
  <pre>
  Msg 8152, Level 16, State 4, Line 1
  String or binary data would be truncated.
  </pre>
  
  <p>what should be the reason for it ?? </p>