Set NOT NULL on blob typed column is not allowed

Asked By Joseph D Saunders 70 points N/A Posted on - 05/21/2014

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. 

• Status: Open
• Question Views: 626
• Answer Count: 1
• Vote Up 1 Vote Down

• Answer Accepted: No
• Question Category: Database

Answered By Wangwe Amos 0 points N/A #190157

Set NOT NULL on blob typed column is not allowed

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

About Wangwe Amos

Questions
0

Answers
250

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 05/21/2014
• Question Category: Database