Using some simple example database:

// We will keep db in the 4 disk files

mDataBase.Create( f, 4, 32 * 1024 )



mDataBase.CollationAttribute(EVColAttribute.kStrength) = EVColAttributeValue.kSecondary

mDataBase.CollationAttribute(EVColAttribute.kCaseFirst) = EVColAttributeValue.kLowerFirst

I've set the collation explicitly to secondary. If I now change one field to have numeric collation:

dim Person_String as VString = mPerson.CreateStringField( "fld_string", 40 )

Person_String.CollationAttribute(EVColAttribute.kNumericCollation) = EVColAttributeValue.kON

then the strength changes to tertiary.

Is this a bug or a feature?