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