title: Converting varchar to nvarchar in SQL Server failed
body: <p>I have SQL Server table that contains columns of type <code>varchar(50)</code> as a result of a CSV import using the SQL Server Import wizard.</p>
  
  <p>I was wanting to know how I can change this data type to <code>nvarchar(9)</code> without getting a SQL Server truncation error.</p>
  
  <p>I tried doing a bulk update to set the data types and column sizes that I need but still had the truncation error message when I tried to load the csv into the empty database table I created (with my required data types that I need).</p>
  
  <p>Grateful for any help.</p>