Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › NULL longtext fields leading to errors
In case it helps anyone else, I found a simple workaround, which fixed the problem.
e.g.
update v_board_all_notices
set site = 'n/a'
where
length(site) = 0 or
length(site) = 1 or
length(site) = 2 or
site = '' or
site is null;
jim