While exporting out to dbf file, iSQL can only output to a minimum of 5 bytes for nvarchar(2) but EMS Data export is able to output a nvarchar(2) to 2 bytes. Perhaps they assume 5 bytes is the minimum the industry is using.
Another problem is the numeric decimal datatype. both iSQL and EMS Data Export can only export to the default storage size of 19bytes (15 + 4) instead of a smaller size. Is there any other floating data type in sql server that's smaller than 19 bytes? I need to export the numeric field to be 11 bytes ( 9 + 2 ), any idea?
Have been using OpenOffice to export to dbf but it can't export directly from SQL2005. So far I have been using SQL 2005 to export the tables to excel format and use OpenOffice Calc to export them to dbf file.