var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Export Has Weird Characters For Numeric Fields
I'm getting weird characters returned for numberic fields.
Below is the export command I'm using. Can someone advise on how to format numeric fields correctly?
export to c:\test\txn2011.txt of del modified by COLDEL0x09 NOCHARDEL SELECT Partner, Profit FROM SchoolBudget;
that is the correct format. If you'd like it in a different format, you would have to change the data type on the select statement. Something like:
SELECT Partner, strip(digits(Profit),l,'0') FROM SchoolBudget