title: How to insert/update accented special characters in laravel
body: <p>I am trying to insert / update accented special characters through Laravel</p>
  
  <p>like </p>
  
  <blockquote>
    <p>çã, á, é, í, ó, ú, ü, ñ</p>
  </blockquote>
  
  <p>and many more.</p>
  
  <p>But laravel is converting into some hex code and insert it into database. Which in return, i am getting content in chinese...</p>
  
  <p>For example:- 
  <strong>i am trying to this</strong></p>
  
  <p><a href="https://i.stack.imgur.com/HIrTp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HIrTp.png" alt="enter image description here"></a></p>
  
  <p><strong>Actual query runs in laravel</strong></p>
  
  <p><a href="https://i.stack.imgur.com/MdKEQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MdKEQ.png" alt="enter image description here"></a></p>
  
  <p><strong>What shown in blade is</strong></p>
  
  <p><a href="https://i.stack.imgur.com/OVU8L.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OVU8L.png" alt="enter image description here"></a></p>
  
  <p>I am using SQL-Server-2008</p>
  
  <p>Data type of column is <code>nvarchar</code> and collation is <code>SQL_Latin1_General_CP1_CI_AI</code></p>
  
  <p>So, what i have conclude is, 
  this is the laravel issue becuase if run query directly in database by prefixing <strong>N</strong> like </p>
  
  <blockquote>
    <p>set 'name' = N'Vishal çã, á, é, í, ó, ú, ü, ñ' </p>
  </blockquote>
  
  <p>then it works fine.</p>
  
  <p><strong>How could we acheive this through laravel ?</strong>  </p>