title: SQL Visual Fox pro 9 - After inserting record some chars code are changed in database (e.g. "À" => "A")
body: <p>I am connecting to Visual FoxPro 9 SQL database and I need to be able to update and insert records in a table. The table I am trying to work with has column with type CHAR(5).</p>
  <p>The problem is that some characters in string I am passing are not stored properly like &quot;À&quot; is after insert or update stored as &quot;A&quot;</p>
  <p>There is a desktop app using this database and creating record from there stores those special characters correctly in database. (BTW I don't know how they connect to DB and how they calling insert statement)</p>
  <p>I am connecting to database like this:</p>
  <pre><code>Provider=VFPOLEDB.1;Data Source=${source};
  </code></pre>
  <p><em>(using Nodejs with node-adodb)</em></p>
  <p>And my update for example looks like this:</p>
  <pre><code>UPDATE vykd01s SET cdok = &quot;taazñ&quot;; 
  </code></pre>
  <p>In this example I try to set value for the column to &quot;taazñ&quot; but it is stored as &quot;taazn&quot; but from UI if I set this value it is stored correctly as &quot;taazñ&quot;</p>
  <p>A try many solutions like casting the value but nothing works.</p>
  <p>This is some information about the column I was able to get</p>
  <pre><code>    TABLE_CATALOG: null,
      TABLE_SCHEMA: null,
      TABLE_NAME: 'vykd01s',
      COLUMN_NAME: 'cdok',
      COLUMN_GUID: null,
      COLUMN_PROPID: null,
      ORDINAL_POSITION: 2,
      COLUMN_HASDEFAULT: false,
      COLUMN_DEFAULT: null,
      COLUMN_FLAGS: 88,
      IS_NULLABLE: false,
      DATA_TYPE: 129,
      TYPE_GUID: null,
      CHARACTER_MAXIMUM_LENGTH: 5,
      CHARACTER_OCTET_LENGTH: 5,
      NUMERIC_PRECISION: null,
      NUMERIC_SCALE: null,
      DATETIME_PRECISION: null,
      CHARACTER_SET_CATALOG: null,
      CHARACTER_SET_SCHEMA: null,
      CHARACTER_SET_NAME: null,
      COLLATION_CATALOG: null,
      COLLATION_SCHEMA: null,
      COLLATION_NAME: null,
      DOMAIN_CATALOG: null,
      DOMAIN_SCHEMA: null,
      DOMAIN_NAME: null,
      DESCRIPTION: null
  </code></pre>
  <p>So in conclusion I need the string I am passing to update or insert statement needs to be stored equally in the database (with same char codes).</p>