Option Compare Database

  • Thread starter Thread starter dhiman2002
  • Start date Start date
D

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
 
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 è)
 
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???
Click to expand...

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


John W. Vinson[MVP]
 
Back
Top