|
<< Click to Display Table of Contents >> Table field types |
  
|
|
<< Click to Display Table of Contents >> Table field types |
|
The number data types from various tables are numerous as a combination of native table format of Paradox, dBASE and FoxPro and the different versions or levels of each of these table formats.
Further the Borland Database Engine also evaluates these BDE native data types mapped to transparent generic data types for export and import as well as to be communicable through a common SQL query language - i.e. not just the "Local SQL" implementation of the ISO SQL-92.
This way the PdxEditor gives the option for displaying either the BDE native data types or the generic data types for what purpose is presently needed.
Below are the data types of the same table presented as the BDE types (for dBASE Level 5) and the generic types respectively.
See also SQL data type translation.
This will display the field types/data types as created with some of the original database management system (DBMS) packages:
that be either of the Borland Paradox, Corel Paradox, Ashton-Tate dBASE, Borland dBASE, Borland Visual dBASE, dBASE Plus, FoxBASE, FoxPro / Visual FoxPro or others.
Especially the dBASE/FoxPro numeric data types might be size wise very restrictive calling for great care if importing numeric data into a dBASE/FoxPro table.
However the PdxEditor takes care of that when importing mapping to safe data types of the current default data base format.
As the purpose of the PdxEditor is to also encompass exporting data to other database systems the generic data types used for export might be interesting as they also are more likely to match the data types of modern third party databases at by translating ensuring to select field types not losing any of the original data.
As the generic data types are translations the size for some types may vary from that of the stored native types.
Below are the generic field types of same table as above.
