Oracle: Cannot insert more than 255 chars into a Sequelize.STRING(1024) column through bulkCreate() : NJS-058: maxSize of 255 is too small for value of length 921 in row 0 about sequelize HOT 3 CLOSED

@hjamil-24 could you or one of your team take a look at this? Do we need to set maxSize in the options somewhere to not be the default 255?

from sequelize.

@hjamil-24 I forgot to update the 1024 max length in the actual model definition and only updated that in the migration file, my bad. The column definitions were different in the migration script file and the model definition. So, It assumed the default 255 chars for that column while inserting the data as that is standard for varchar2 but at the database end it was set to 1024. This was a issue on my end. Thanks for your help.

from sequelize.

We don't need any settings. If text : {type: Sequelize.STRING(1024)} is defined, that would allow the user to enter string of more than 255 chars.

@AbuzarHussain, the example you provided doesn't throw error (when written completely).
Can you provide with complete demo example, if the issue is still there?
What kind of data is provided? (take length consideration into account when using multibyte data)
Has there been any database configuration you might have done earlier?
Happy to help :)

from sequelize.