title: SQL UPDATE doesn't work with foreign languages (Arabic)
body: <p>the UPDATE gives  <code>????</code> if the updater field was written in Arabic and this is my query:</p>
  
  <pre><code>UPDATE  students 
  SET first_name = 'الاسم' , last_name = 'الاسم الاخير' , 
      father_name = 'الاسم الاخير' , mother_name = '', 
      birth_date = '1/1/1990 12:00:00 AM' , education_level = '' , 
      address = '' , notes = '' 
  WHERE student_id = 33
  </code></pre>
  
  <p>And here is the result of the update:</p>
  
  <pre><code>student_id  first_name  last_name   mother_name     father_name   birth_date    
  33           ?????      ?????          ??????       ???????????   1990-01-01
  </code></pre>
  
  <p>//the answer is great and thank you people, another question is that I am using this UPDATE syntax in my C# program</p>
  
  <pre><code>command.CommandText = "UPDATE  students SET " +
          "first_name = " + "'" + first_name + "'" + " , last_name = " + "'" + last_name + "'" +
           " , father_name = " + "'" + father_name + "'" + " , mother_name = " + 
          "'" + mother_name + "'" + ", birth_date = " + "'" + birth_date + "'" +
          " , education_level = " + "'" + education_level + "'"  +
          " , address = " + "'" + address + "'" + " , notes = " + "'" + notes + "'" +
          " WHERE student_id = " + id ;
  </code></pre>
  
  <p>//how to use the character N</p>