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

BubikolRamios's profile image BubikolRamios posted 5 years ago in General Permalink
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.
krishna's profile image krishna posted 3 months ago Permalink

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.