title: SQLite MYSQL character encoding
body: <p>I have a strange situation where the following code works however XCode warns it is deprecated...</p>
  
  <pre><code>NSString *col1 = [NSString stringWithCString:(char *)sqlite3_column_text(compiledStatement, 0)];
  </code></pre>
  
  <p>However as that is the deprecated method if I set an encoding the string comes out wrong!  I have tried all the encodings but none work!</p>
  
  <pre><code>NSString *col1 = [NSString stringWithCString:(char *)sqlite3_column_text(compiledStatement, 0) encoding:NSASCIIStringEncoding];
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/hYPhE.png" alt="enter image description here"></p>