title: Advantage Database Index Collation Sequence
body: <p>I am converting a Delphi program from the BDE to Advantage Database. </p>
  
  <p>On weekends I work on a Win 7 machine using Delphi XE. During the week I work on a Win XP machine using Delphi 7.</p>
  
  <p>Advantage tables work fine on the Win 7 machine but when copied to the XP machine they cannot be accessed - <code>Error 5175 the index was created with a different collation sequence</code></p>
  
  <p>I have searched the net, even gone into the Advantage forums but can't find anything helpful.</p>
  
  <p>The XP and Win 7 are both set up the same as regards location etc. Table properties lists the collation sequence as blank.</p>
  
  <p>Anyone know what is causing this and how to fix. I have tried dropping and recreating the indices but to no avail.</p>