title: MySQL to SQL Server - Incorrect syntax near the keyword 'mictest'
body: <p>First, I tried to migrate my databases with SQL Server Migration Assistant for MySql and it worked fine.</p>
  
  <p>But now, I have some problems with my code.</p>
  
  <p>I had this line on MYSQL version :</p>
  
  <pre><code>$fct="SELECT * FROM `users` WHERE `USER` LIKE CONVERT( _utf8 '$LOGIN' USING latin1 ) COLLATE latin1_swedish_ci AND `PASS` LIKE CONVERT( _utf8 '$PASS'USING latin1 ) COLLATE latin1_swedish_ci";
  </code></pre>
  
  <p>This line worked fine but when i try to put this on my SQL Version i get :</p>
  
  <p>Error : <code>SQLSTATE[42000]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax with the keyword 'mictest'.</code> (which is my $LOGIN)</p>
  
  <p>I though it was a problem with "quotes" so I also tried this but it is not working :</p>
  
  <pre><code>$fct="SELECT * FROM users WHERE USER LIKE CONVERT( _utf8 '$LOGIN' USING latin1 ) COLLATE latin1_swedish_ci AND PASS LIKE CONVERT( _utf8 '$PASS' USING latin1 ) COLLATE latin1_swedish_ci";
  </code></pre>