I'm using BRIGHTHOUSE engine.
I have a column defined as varchar(100). When loading data into the table, if the column data exceeds 100 characters, the engine will throw 'Wrong data or column definition' error, and fail to complete the loading process.
I'm wondering wether I can change the behaviour, simply discard the extra characters, just like what MySQL will do.
I've checked out the reject file feature, but it's not what I want.
The only way I can think of is to truncate the column data when generating the data file. It's workable, but not as easy as in MySQL.
Thanks in advanced.