Option Compare Database

[dhiman2002]

Hi,
On looking up the help for Option Compare Database in access, it says
that :

Option Compare Database can only be used within Microsoft Access. This
results in string comparisons based on the sort order determined by the
locale ID of the database where the string comparisons occur.


I dont understand what does "the sort order determined by the locale ID
of the database where the string comparisons occur." mean????

Can anyone just explain it real easily???

Thx
Dhiman

 

[Douglas J. Steele]

When the database is created, a Locale is associated with it. (Look up the
CreateDatabase method in the Help file to see what the choices are). If you
choose "Option Compare Database", the Locale associated with the database
will determine the sort sequence (i.e.: will é sort before or after ê and è)

 

[John Vinson]

I dont understand what does "the sort order determined by the locale ID
of the database where the string comparisons occur." mean????

Can anyone just explain it real easily???

The "Locale" has to do with the language. Alphabetical order can be
different in English, Spanish, Greek, Japanese...


John W. Vinson[MVP]