title: Comparing Strings in where clause
body: <p>Hello I am confused according to string comparison in sql.  </p>
  
  <pre><code>select * from table where column1 = 'abc';
  </code></pre>
  
  <p>As I understand the string 'abc' is converted to a number let us pretend (1+2+3=6) for this example.  </p>
  
  <p>This means that </p>
  
  <pre><code>select * from table where column1 = 'cba'; 
  </code></pre>
  
  <p>will also have the same value 6. The Strings are not the same. Please enlighten me.</p>
  
  <p>Edit: Because you think this is a joke.</p>
  
  <p>"The character letter King is converted to a numeric representation. Assuming a US7ASCII database character set with AMERICAN NLS settings, the literal king is converted into a sum of its ordinal character values: K+i+n+g = (75+105+110+103=393)." </p>
  
  <p>This is the exact text from a book that made me confused. </p>