Comparing Kexi to other database applications
Prev

Appendix B.  Comparing Kexi to other database applications

Table of Contents

Data types

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.

Data types

The table below shows how the data types in Kexi correspond to data types in other database applications.

Some of the data types listed here are sub-types of other types. For example, the Long text type is a sub-type of the Text 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 Subtype setting in the Properties Editor.

Table B.1.  Comparison of data types used in Kexi and other database applications

KexiMS AccessdBase/FoxProParadox
Text (Text)TextCharacterAlphanumeric
Long text (Long text)MemoMemoMemo
Date/Time (Date/Time)Date, TimeDateDateTime
Integer Number (Integer Number)Number (Integer)NumericInteger
Big Integer Number (Big Integer Number)Long IntegerNumericLong Integer
Floating Point Number (Floating Point Number)Single/Double precision numberFloatNumber
Prev
Home


Would you like to comment or contribute an update to this page?
Send feedback to the TDE Development Team