Kexi/Handbook/Comparing Kexi to other database applications/Data types/da
Datatyper
Selvom forskellige databaseprogrammer typisk udbyder nogenlunde samme funktionalitet, så bruger de forskellige betegnelser. Dette appendiks viser hvordan Kexis terminologi relaterer til andre databaseprogrammers. Dette kapitel kn således være nyttigt når du overfører databaser fra et program til et andet.
Tabellen herunder viser, hvordan Kexis datatyper svarer til datatyper i andre databaseprogrammer.
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 |