Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

BLOB/TEXT column can't have a default value

624 posts

BubikolRamios posted 8 years ago in General

if you have a field in table like this:
`f` VARCHAR(200) NOT NULL DEFAULT ' '
and then try to change that to TEXT type -->

SQL Error (1101): BLOB/TEXT column 'f' can't have a default value

Changing should in that case automaticaly assign 'no default value' to that field.

1 posts

krishna posted 3 years ago

ERROR 1101 (42000) at line 1489: BLOB/TEXT column 'courseids' can't have a default value

Please login to leave a reply, or register at first.