var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Exported field truncated
I issued the following SQL to export data:
echo EXPORT TO D:\eCRM_Black_List_Download\bkblist.del OF DEL MESSAGES D:\eCRM_Black_List_Download\bkblist.log select black_key, input_date, source_code, internal_code, black_list_name, other_number, passport, address, effective_date, expired_date, substr(remark,8), access_control from fos.black_list; >> batch.clp
But the address and remark columns were truncated. If import it to excel with macro process, it will not extract all records.
Please help anyway not to truncate the exported file.
Thank you very much.
You're running an explicit substr function on the remark field. What is the datatype for the fields? Are the CLOBS?
Originally Posted by
The address field is VARCHAR 250 and for remark field is BLOB.
I'm surprised VARCHAR(250) is truncated ... Did you check the exported file in notepad ?? Is is truncated ?
Remember BLOB works on bytes ... So, if you are using DBCS only first 4 characters will be returned by SUBSTR(blobcol,8)
Visit the new-look
, register to gain access to the excellent content.
Exported Fields Truncated
I did view through notepad and realised it was truncated.
I suspected if I'm not wrong, there may be some 'carriage return' which caused the trucation.
anyway we can filter off this truncation during exporting??
Please help. Thank you so much.