← Back to branch summary

~ubuntu-branches/ubuntu/precise/koffice/precise

« back to all changes in this revision

Viewing changes to doc/kexi/comparing.docbook

  • Committer: Bazaar Package Importer
  • Author(s): Jonathan Riddell
  • Date: 2010-09-21 15:36:35 UTC
  • mfrom: (1.4.1 upstream) (60.2.11 maverick)
  • Revision ID: james.westby@ubuntu.com-20100921153635-6tejqkiro2u21ydi
Tags: 1:2.2.2-0ubuntu3
Add kubuntu_03_fix-crash-on-closing-sqlite-connection-2.2.2.diff and
kubuntu_04_support-large-memo-values-for-msaccess-2.2.2.diff as
recommended by upstream http://kexi-
project.org/wiki/wikiview/index.php@Kexi2.2_Patches.html#sqlite_stab
ility

Show diffs side-by-side

added added

removed removed

Lines of Context:
doc/kexi/comparing.docbook
 
1
<!--
 
2
  <!DOCTYPE chapter PUBLIC "-//KDE//DTD DocBook XML V4.2-Based Variant V1.1//EN" "dtd/kdex.dtd" >
 
3
-->
 
4
 
 
5
<appendix id="comparing">
 
6
  <title>
 
7
    Comparing &kexi; to other database applications
 
8
  </title>
 
9
  <para>
 
10
    Although different database applications tend to provide similar
 
11
    functionality, they often use different terminology.  For your
 
12
    convenience, this appendix shows how the terminology used in
 
13
    &kexi; corresponds to that used by other database applications.
 
14
    Thus, this chapter may be useful when migrating databases from
 
15
    one application to another.
 
16
  </para>
 
17
  <sect1 id="comparing-data-types">
 
18
    <title>
 
19
      Data types
 
20
    </title>
 
21
      <para>
 
22
        The table below shows how the data types in &kexi; correspond
 
23
        to data types in other database applications.
 
24
      </para>
 
25
      <para>
 
26
        Some of the data types listed here are
 
27
        <firstterm>sub-types</firstterm> of other types.  For example,
 
28
        the <emphasis>Long text</emphasis> type is a sub-type of the
 
29
        <emphasis>Text</emphasis> type.  To use a sub-type in
 
30
        &kexi;, you should select the corresponding basic type (in
 
31
        this case, Text) in the table designer, and then select the
 
32
        sub-type using the <guilabel>Subtype</guilabel> setting in the
 
33
        <guilabel>Properties Editor</guilabel>.
 
34
      </para>
 
35
      <table>
 
36
      <title>
 
37
        Comparison of data types used in &kexi; and other database
 
38
        applications
 
39
      </title>
 
40
      <tgroup cols="4">
 
41
        <thead>
 
42
          <row>
 
43
            <entry>&kexi;</entry>
 
44
            <entry>MS Access</entry>
 
45
            <entry>dBase/FoxPro</entry>
 
46
            <entry>Paradox</entry>
 
47
          </row>
 
48
        </thead>
 
49
        <tbody>
 
50
          <row>
 
51
            <entry>Text (Text)</entry>
 
52
            <entry>Text</entry>
 
53
            <entry>Character</entry>
 
54
            <entry>Alphanumeric</entry>
 
55
          </row>
 
56
          <row>
 
57
            <entry>Long text (Long text)</entry>
 
58
            <entry>Memo</entry>
 
59
            <entry>Memo</entry>
 
60
            <entry>Memo</entry>
 
61
          </row>
 
62
          <row>
 
63
            <entry>Date/Time (Date/Time)</entry>
 
64
            <entry>Date, Time</entry>
 
65
            <entry>Date</entry>
 
66
            <entry>DateTime</entry>
 
67
          </row>
 
68
<!-- Not visible in Kexi GUI yet.
 
69
          <row>
 
70
            <entry>Object (Object)</entry>
 
71
            <entry>OLE Object</entry>
 
72
            <entry>General</entry>
 
73
            <entry>OLE, Graphical Binary</entry>
 
74
          </row>
 
75
-->
 
76
          <row>
 
77
            <entry>Integer Number (Integer Number)</entry>
 
78
            <entry>Number (Integer)</entry>
 
79
            <entry>Numeric</entry>
 
80
            <entry>Integer</entry>
 
81
          </row>
 
82
          <row>
 
83
            <entry>Big Integer Number (Big Integer Number)</entry>
 
84
            <entry>Long Integer</entry>
 
85
            <entry>Numeric</entry>
 
86
            <entry>Long Integer</entry>
 
87
          </row>
 
88
          <row>
 
89
            <entry>Floating Point Number (Floating Point Number)</entry>
 
90
            <entry>Single/Double precision number</entry>
 
91
            <entry>Float</entry>
 
92
            <entry>Number</entry>
 
93
          </row>
 
94
        </tbody>
 
95
      </tgroup>
 
96
    </table>
 
97
  </sect1>
 
98
</appendix>