Set NOT NULL on blob typed column is not allowed

Asked By 70 points N/A Posted on -
qa-featured

Hello DBA’s

I got this weird error message when I try to run a query in the database. I do not understand where I went wrong. I tried to trace the root cause of this error but I cannot. It says the error is in the line, but not able to find it. Please guide me to resolve this error message. Is there any other method available to track the error? Thanks a lot. Your help is great.

Warning

Query Error.Error content is as follows.Skip?

Execute error:-1014

1’th line is not executed (error)

Error description:

Set NOT NULL on blob typed column is not allowed. 

SHARE
Answered By 0 points N/A #190157

Set NOT NULL on blob typed column is not allowed

qa-featured

The "Set NOT NULL on blob typed column is not allowed" error you are experiencing is due to BLOB (Binary Large Object) not having a default value. Default value is not assigned to text columns either. To read more about this long standing bug (or, as some say, implementation), access an archived discussion by clicking here

Related Questions