"length mismatch between programinfo" error v0.23

[awa_wp@…]

When EIT data consist some garbage (for example binary data) and this data are saved to recorded table into text fields, some MythTV function crash with "length mismatch between programinfo" message.
For example "Watch Recordings" list is empty, but I can see recorded things in "Previous Recorded" list.
When I manually correct the table all works fine to the next recording.
In my case affected fields is a subtitle and description.
I am attaching a file with an incorrect and a corrected recorded table.

[awa_wp@…]

I prepare simple workaround for this error:

delimiter

CREATE TRIGGER recorded_check_insert BEFORE INSERT ON recorded FOR EACH ROW BEGIN

IF NEW.subtitle = '\0' THEN

SET NEW.subtitle = ;

END IF; IF NEW.description = '\0' THEN

SET NEW.description = ;

END IF;

END;

CREATE TRIGGER recorded_check_update BEFORE UPDATE ON recorded FOR EACH ROW BEGIN

IF NEW.subtitle = '\0' THEN

SET NEW.subtitle = ;

END IF; IF NEW.description = '\0' THEN

SET NEW.description = ;

END IF;

END;

CREATE TRIGGER program_check_insert BEFORE INSERT ON program FOR EACH ROW BEGIN

IF NEW.subtitle = '\0' THEN

SET NEW.subtitle = ;

END IF; IF NEW.description = '\0' THEN

SET NEW.description = ;

END IF;

END;

CREATE TRIGGER program_check_update BEFORE UPDATE ON program FOR EACH ROW BEGIN

IF NEW.subtitle = '\0' THEN

SET NEW.subtitle = ;

END IF; IF NEW.description = '\0' THEN

SET NEW.description = ;

END IF;

END;

delimiter ;

[awa_wp@…]

Posted SQL code has been changed by a website parser and not work.

sql_trigger.sql consist valid code.

[Raymond Wagner]

Duplicate of #8707. Possibly related to #6663.