diff -r 4816d766a08a -r f345bda72bc4 Symbian3/PDK/Source/GUID-79B699F5-5EDE-5561-A385-19ED02248398.dita
--- a/Symbian3/PDK/Source/GUID-79B699F5-5EDE-5561-A385-19ED02248398.dita	Tue Mar 30 11:42:04 2010 +0100
+++ b/Symbian3/PDK/Source/GUID-79B699F5-5EDE-5561-A385-19ED02248398.dita	Tue Mar 30 11:56:28 2010 +0100
@@ -1,12 +1,26 @@
-<?xml version="1.0" encoding="utf-8"?>
-<!-- Copyright (c) 2007-2010 Nokia Corporation and/or its subsidiary(-ies) All rights reserved. -->
-<!-- This component and the accompanying materials are made available under the terms of the License 
-"Eclipse Public License v1.0" which accompanies this distribution, 
-and is available at the URL "http://www.eclipse.org/legal/epl-v10.html". -->
-<!-- Initial Contributors:
-    Nokia Corporation - initial contribution.
-Contributors: 
--->
-<!DOCTYPE concept
-  PUBLIC "-//OASIS//DTD DITA Concept//EN" "concept.dtd">
-<concept xml:lang="en" id="GUID-79B699F5-5EDE-5561-A385-19ED02248398"><title>Indexes</title><prolog><metadata><keywords/></metadata></prolog><conbody><p>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. </p> <p>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.</p> <p>Apart from <codeph>Binary</codeph> and <codeph>LongBinary</codeph> columns, all types can be used in an index key including <codeph>LongText8</codeph> and <codeph>LongText16</codeph>, although these must supply a truncation length (as they have no maximum length) and must therefore be the last key columns in the key.</p> </conbody></concept>
\ No newline at end of file
+<?xml version="1.0" encoding="utf-8"?>
+<!-- Copyright (c) 2007-2010 Nokia Corporation and/or its subsidiary(-ies) All rights reserved. -->
+<!-- This component and the accompanying materials are made available under the terms of the License 
+"Eclipse Public License v1.0" which accompanies this distribution, 
+and is available at the URL "http://www.eclipse.org/legal/epl-v10.html". -->
+<!-- Initial Contributors:
+    Nokia Corporation - initial contribution.
+Contributors: 
+-->
+<!DOCTYPE concept
+  PUBLIC "-//OASIS//DTD DITA Concept//EN" "concept.dtd">
+<concept id="GUID-79B699F5-5EDE-5561-A385-19ED02248398" xml:lang="en"><title>Indexes</title><shortdesc>Most datatypes can be used in indexes, but there are restrictions
+when using <codeph>LongText</codeph> data types.</shortdesc><prolog><metadata><keywords/></metadata></prolog><conbody>
+<p>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. </p>
+<p>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.</p>
+<p>Apart from <codeph>Binary</codeph> and <codeph>LongBinary</codeph> columns,
+all types can be used in an index key including <codeph>LongText8</codeph> and <codeph>LongText16</codeph>,
+although these must supply a truncation length (as they have no maximum length)
+and must therefore be the last key columns in the key.</p>
+</conbody></concept>
\ No newline at end of file