Kexi/Handbook/Comparing Kexi to other database applications/Data types/en: Difference between revisions
(Updating to match new version of source page) |
(Updating to match new version of source page) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 6: | Line 6: | ||
The table below shows how the data types in '''Kexi''' correspond to data types in other database applications. | 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 ''' | 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 '''Property Editor'''. | ||
{|class="tablecenter" style="border: 1px solid grey;" | {|class="tablecenter" style="border: 1px solid grey;" <!--}--> | ||
|+ ''Comparison of data types used in Kexi and other database applications'' | |+ ''Comparison of data types used in Kexi and other database applications'' | ||
! '''Kexi''' !! '''MS Access''' !! '''dBase/FoxPro''' !! '''Paradox''' | ! '''Kexi''' !! '''MS Access''' !! '''dBase/FoxPro''' !! '''Paradox''' | ||
| Line 23: | Line 23: | ||
|- | |- | ||
| Floating Point Number (Floating Point Number) || Single/Double precision number || Float || Number | | Floating Point Number (Floating Point Number) || Single/Double precision number || Float || Number | ||
|} | |} <!--{--> | ||
Latest revision as of 17:00, 7 April 2012
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.
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 Property Editor.
| Kexi | MS Access | dBase/FoxPro | Paradox |
|---|---|---|---|
| Text (Text) | Text | Character | Alphanumeric |
| Long text (Long text) | Memo | Memo | Memo |
| Date/Time (Date/Time) | Date, Time | Date | DateTime |
| Integer Number (Integer Number) | Number (Integer) | Numeric | Integer |
| Big Integer Number (Big Integer Number) | Long Integer | Numeric | Long Integer |
| Floating Point Number (Floating Point Number) | Single/Double precision number | Float | Number |