Hi,
If I create a secondary index where the first part of the index is this
(using the associate() function):

typedef unsigned long ATYPE_NUMBER;
ATYPE_NUMBER value;
memcpy(&value, key.data, sizeof(ATYPE_NUMBER));
// Key:
// ATYPE_NUMBER + ASCII characters

If I then close the primary database, and only open the secondary
database for reading only, will the secondaries keys be sorted from
from 0 to N (unsigned long)?

I have done this and the secondary index does not appear to be sorted
correctly by unsigned long, but the data seems to be correct. Any
suggestions?
Thanks

Hi,

If you are doing this on a big endian machine (Sparc, PPC, and so on),
the items will be sorted as you expect. If you're on a little-endian
machine (x86 and friends), the items won't sort in the order you
expect. Please see this FAQ entry for more information:

http://dev.sleepycat.com/resources/faq_show.html?id=70

Regards,
Michael.