title: Laravel, SQL varchar
body: <p>I am Using laravel with MS SQL. When string datatype is defined in the migration (code attahced) laravel create a nvarchar datatype in the Database instead of varchar. How to restrict laravel or SQL Server to create varchar datatype when a datatype of string is defined in migration.</p>
  
  <p>Following is the code for migration</p>
  
  <pre><code>public function up()
  {
      Schema::create('ie_applicant_type', function (Blueprint $table) {
          $table-&gt;increments('applicant_type_id');
          $table-&gt;string('applicant_type');
          $table-&gt;timestamps();
      });
  }
  </code></pre>
  
  <p>and sqlsrv is default in config/database</p>
  
  <pre><code>'default' =&gt; env('DB_CONNECTION', 'sqlsrv')
  </code></pre>
  
  <p>but still nvarchar data type is created when the migration is run instead of varchar. SQL Pic attached</p>
  
  <p><a href="https://i.stack.imgur.com/MdraJ.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MdraJ.jpg" alt="Datatype created on running the migration"></a></p>