Which is the correct text comparison method for an international application ... AnsiCompareText or CompareText?

Question

I am using Delphi 2009 to write an application using an Access database.

I noticed that MS Access ORDER BY seems to sort international character sets such as AnsiCompareText, whereas in my entire application I use SysUtils.CompareText.

Access' (Jet's) ORDER BY results (delphi AnsiCompareText( ) is the same)
  Nørmork
  Öster
  RAM

delphi CompareText( )
  Nørmork
  RAM
  Öster

Which correct call should I use for comparison?

Note. I use USA English as my language.

Sorry, I don’t know much about this. There are many websites that discuss related topics in detail, but I have not seen the discussions that work best.

Thanks!

Answer 1

CompareText ASCII, AnsiCompareText ANSI ( Delphi 2009+ Unicode) . CompareText , .

Answer 2

, - , , , . AnsiCompareText, .