Why can't I turn the default of a column into an empty string?

[narutodude000]

I have a few columns that have a default of NULL. I tried turning them into "As define:" (empty string) with phpMyAdmin many times before. But it's still NULL and it's causing errors in my script.

[thraddash]

If your trying to set a default value for a TEXT type column it's not going to accept it.
Easy solution is to set the column to allow null values.

Eg.

ALTER TABLE [table_name] MODIFY COLUMN [column_name] TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL;

[WolfShade]

Have you tried setting the default value to two apostophes? ''

This is how I set a blank as the default in MS-SQL Server, via Management Studio Express.

^_^