MacResource
Why would a database program truncate fields on export? - Printable Version

+- MacResource (https://forums.macresource.com)
+-- Forum: My Category (https://forums.macresource.com/forumdisplay.php?fid=1)
+--- Forum: Tips and Deals (https://forums.macresource.com/forumdisplay.php?fid=3)
+--- Thread: Why would a database program truncate fields on export? (/showthread.php?tid=20271)



Why would a database program truncate fields on export? - Greg the dogsitter - 10-09-2006

Both Access and MapInfo (combination of mapping and database software) truncate numeric fields when you export information into, say, CSV format. There are workarounds, but is there any technical reason why this needs to occur?


Re: Why would a database program truncate fields on export? - mattkime - 10-09-2006

So you have a reason to buy SQL server


Re: Why would a database program truncate fields on export? - Don C - 10-10-2006

Number of permitted characters?