A collection of technical bits for me to remember and maybe help others find a solution before pulling out their hair.
ALTER table table_name MODIFY somecolumn varchar(64) NOT NULL