|
<< Click to Display Table of Contents >> Export |
![]() ![]()
|
If you do know the target application is for example an arcade dBASE IV application, prepare the field names from by dBase undesireably being truncated to max. 10 characters accepting only alphanumerics and underscore.
Also, do consider if the receiving database can handle the specific data types.
Although most modern databases do accept longer field names, many still do have some restrictions as e.g. dBASE 7 tables, though accepting long field names and spaces, still does not accept punctuation or special characters except underscore.
Also consider, MS Access not accepting points in field names.
So, even though Paradox may accept some rather weird field names
![]()
this generally is considered to be poor database praxis, and most databases will refuse!
Also, do consider if the receiving database will accept field and table names with characters beyond the basic ASCII character set (A..Z/a..z), and if it does, do consider how the beyond ASCII characters will appear if data is ported to another language region.
See Binary data fields and Binary import/export.
__________________________