MySQL Defaults question

[frostyservant]

According to the MySQL documentation, "Text" and "Blob" columns can't have defaults. Anyone know a way around this? I would simply use isset() in my php script to determine if the user had input a value or not, and write in a default value for them if they hadn't, but there's a whole seperate litany of problems there that I'd rather not deal with if I don't have to.

[sde]

hmm .. can you set the default to NULL? then with mysql, you can check with:

select * from table where mytextfield is NULL

alternatively, if there was no default null set, and you wanted to query for the text fields that have no data, you could do this:

select * from table where mytextfield = ''

i don't know what exactly you are trying to accomplish, but give me more info if i didn't help. sometimes taking a step back and re-evaluating how you are trying to accomplish what you need to do helps.

[frostyservant]

Sorry it took me so long to get back.

I've since figured out a PHP-based solution using addslashes(), but thank you for the help.