CODEWITHSUNDEEP
sql-serversql-server-2012delete-rowvarcharmax
Steve Waters
Steve Waters

Reputation: 3548

Can't delete a row from database with empty value on text-type column

While trying to remove a row from my database in SQL Squirrel I get the following error.

enter image description here

Now, this happens when the text-type column has value '' (as in empty) When it has null, there's no error when deleting.

Why is this? Would it help if I convert the column to be of type varchar(max) instead of text and are there any possible dangers in that?

Upvotes: 0

Views: 435

Answers (1)

user8561960
user8561960

Reputation: 

An empty string is a string with zero length or no character. Null is absence of data


used delete statement with [text-type column ='' OR text-type column is NULL]

Upvotes: 0

Related Questions