I created a sample model for MySQL 5 and added a two lines long comment to one of the entities (one carriage return).
) ENGINE = InnoDB
ROW_FORMAT = Compact
COMMENT = ‘this is just
Then created the database physically and tried to reverse engineer it. The comment was loaded properly. Then I generated HTML report and the comment was OK again.
What software did you use for physical creation of the database? E.g. MySQL Query Browser allows you to enable or disable options like “Create Windows style line breaks (LF CR)”, Enable friendly line breaks, Substitude CR, Substitude LF etc. Please try to play a little with these options, if you use this software.
BTW: I used HeidiSQL (http://www.heidisql.com/).
Re: character escaping: I believe it’s OK to escape the <> characters. Imagine that you write XML code in your comments. Such comments will not be displayed in the report. Also, what if you wish to see HTML CODE, including all tags etc?