| author | Dominic Pinkman <Dominic.Pinkman@Nokia.com> |
| Fri, 22 Jan 2010 18:26:19 +0000 | |
| changeset 1 | 25a17d01db0c |
| child 3 | 46218c8b8afa |
| permissions | -rw-r--r-- |
|
1
25a17d01db0c
Addition of the PDK content and example code for Documentation_content according to Feature bug 1607 and bug 1608
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff
changeset
|
1 |
<?xml version="1.0" encoding="utf-8"?> |
|
25a17d01db0c
Addition of the PDK content and example code for Documentation_content according to Feature bug 1607 and bug 1608
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff
changeset
|
2 |
<!-- Copyright (c) 2007-2010 Nokia Corporation and/or its subsidiary(-ies) All rights reserved. --> |
|
25a17d01db0c
Addition of the PDK content and example code for Documentation_content according to Feature bug 1607 and bug 1608
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff
changeset
|
3 |
<!-- This component and the accompanying materials are made available under the terms of the License |
|
25a17d01db0c
Addition of the PDK content and example code for Documentation_content according to Feature bug 1607 and bug 1608
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff
changeset
|
4 |
"Eclipse Public License v1.0" which accompanies this distribution, |
|
25a17d01db0c
Addition of the PDK content and example code for Documentation_content according to Feature bug 1607 and bug 1608
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff
changeset
|
5 |
and is available at the URL "http://www.eclipse.org/legal/epl-v10.html". --> |
|
25a17d01db0c
Addition of the PDK content and example code for Documentation_content according to Feature bug 1607 and bug 1608
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff
changeset
|
6 |
<!-- Initial Contributors: |
|
25a17d01db0c
Addition of the PDK content and example code for Documentation_content according to Feature bug 1607 and bug 1608
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff
changeset
|
7 |
Nokia Corporation - initial contribution. |
|
25a17d01db0c
Addition of the PDK content and example code for Documentation_content according to Feature bug 1607 and bug 1608
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff
changeset
|
8 |
Contributors: |
|
25a17d01db0c
Addition of the PDK content and example code for Documentation_content according to Feature bug 1607 and bug 1608
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff
changeset
|
9 |
--> |
|
25a17d01db0c
Addition of the PDK content and example code for Documentation_content according to Feature bug 1607 and bug 1608
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff
changeset
|
10 |
<!DOCTYPE concept |
|
25a17d01db0c
Addition of the PDK content and example code for Documentation_content according to Feature bug 1607 and bug 1608
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff
changeset
|
11 |
PUBLIC "-//OASIS//DTD DITA Concept//EN" "concept.dtd"> |
|
25a17d01db0c
Addition of the PDK content and example code for Documentation_content according to Feature bug 1607 and bug 1608
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff
changeset
|
12 |
<concept xml:lang="en" id="GUID-47419CFB-163D-5A4E-8A00-C73773353BDF"><title>Column type characteristics</title><prolog><metadata><keywords/></metadata></prolog><conbody><p>DBMS has a rich set of column types. </p> <p>The Store database implementation supports all column types, and any column type can be nullable or marked as not-null.</p> <section><title>Fixed width columns</title> <p>All numeric and date/time columns are fixed width, though <codeph>Null</codeph> values will take no extra storage space in the database. See <xref href="GUID-4D96BFA5-3C4F-320F-BA9F-3511925A8137.dita"><apiname>TDbColType</apiname></xref> for the characteristics of fixed width column types.</p> </section> <section><title>Variable width columns</title> <p>Text and Binary columns are all variable length.</p> <p>The short column types <codeph>Text8</codeph>, <codeph>Text16</codeph> and <codeph>Binary</codeph> support the maximum length attribute, and can only store up to 255 units (characters or bytes) of data. If <codeph>KDbUndefinedLength</codeph> is specified as the maximum length attribute for these column types when a table is created, they are given a maximum length of 255.</p> <p>Long column types <codeph>LongText8</codeph>, <codeph>LongText16</codeph> and <codeph>LongBinary</codeph> can theoretically store up to 2GB of data depending on resources available in the store, at the cost of a little more storage overhead than short columns.</p> <p>A <codeph>Null</codeph> variable length column is one with no data in it, in particular DBMS does not distinguish between a zero-length Text column and a <codeph>Null</codeph> value Text column. See <xref href="GUID-4D96BFA5-3C4F-320F-BA9F-3511925A8137.dita"><apiname>TDbColType</apiname></xref> for the characteristics of the variable width column types.</p> <p>See also:</p> <ul><li id="GUID-4D82433D-E17F-5572-8054-6AE364616C54"><p><xref href="GUID-785B2F0B-E7E6-5DAE-98F1-6C32BED25964.dita">Database storage overhead</xref> </p> </li> </ul> </section> </conbody></concept> |