Cannot import Binary data correctly. Import gives error: "syntax error near ')' ". (4234999)

Unable to import Binary data correctly. Import gives error: "syntax error near ')' ".

Toad first recognizes the data as varchar. If this is corrected in the Wizard to specify binary(8) manually, at the end of the import, it errors out with "syntax error near ')'" and the data is not imported.

Other Possible Errors:

2:38:03 PM Thread (8) Row 1 failed to insert, error: The column asset_id in table customer.reporter.cv_AssetID_ISIN_CUSIP List does not allow null values.

2:38:17 PM Thread (8) Inserting data into table customer.reporter.[cv_AssetID_ISIN_CUSIP List] generated an error. The column asset_id in table customer.reporter.cv_AssetID_ISIN_CUSIP List does not allow null values.

2:38:17 PM Thread (8) Nothing to discard, delete C:\0_Current Work\1_MyProjects_Current\SSGT\SSGA_RRPS_history_015.csv\assetid_cusip_isin_rows_with_error.csv

2:38:17 PM Thread (8) Import canceled and inserted rows were rolled back.

2:38:17 PM Thread (8) Error importing data, please check file format options: Inserting data into table customer.reporter.[cv_AssetID_ISIN_CUSIP List] generated an error. The column asset_id in table customer.reporter.cv_AssetID_ISIN_CUSIP List does not allow null values.

Steps to Replicate:

1) Tools | Import | Import wizard.
2) Select an .xlsx file that contains binary data (one column). Issue also happens on .csv files.
3) When selecting target, choose to create "A single new table".
4) Manually adjust type and set to BINARY for the column that holds the binary data, and set a length, e.g. BINARY(8).
5) Continue on through import wizard... at the end click Finish.
6) Toad will error out with missing parenthesis error.

The reason the Import is not working is due to the following types are not supported for import in TDP.

Not supported types on ASE for import:

- BINARY
- VARBINARY
- IMAGE

Not supported types for Oracle for import:

- CLOBS
- BLOBS

There are no plans to add the above types in TDP for Import (as an Enhancement Request or ER) because TDP is a data query tool and does not specialize in data entry or updating.

If you would like to submit the above as an Enhancement Request (ER) for TDP, please visit the Toad Idea Pond site and log an enhancement request for this feature.  This site is solely dedicated to tracking customer enhancement requests and allowing the user community to vote on the most useful feature.  The Development Team personally monitors this website and provides customer feedback on their enhancement requests.