Most datatypes can be used in indexes, but there are restrictions when using LongText data types.
Indexes in the store database are B+tree structures with a fixed size key. This means that text keys may easily generate large indexes, and a maximum length text column cannot be indexed.
Keys in DBMS may be truncated by specifying the length of a text column to be used in the index key. Such a key column must always be the last one in the key, to ensure that the index provides a true ordering. If a text key column does not supply a truncation length, the full length of the table column is used.
Apart from Binary and LongBinary columns, all types can be used in an index key including LongText8 and LongText16 , although these must supply a truncation length (as they have no maximum length) and must therefore be the last key columns in the key.
Copyright ©2010 Nokia Corporation and/or its subsidiary(-ies).
All rights reserved. Unless otherwise stated, these materials are provided under the terms of the Eclipse Public License v1.0.