Menu

#573 MariaDB 10.2: newline in table and column comments

4.3.1
closed-fixed
nobody
None
5
2018-01-22
2017-09-26
kbudde
No

Hello,

it is possible, to format table and column comments with newlines via create and alter statements.
Why don't show adminer these newlines in the table description?

For example:
CREATE TABLE table_test (
def_id int(10) unsigned NOT NULL COMMENT 'DefinitionsId
zweite Zeile im Kommentar
dritte Zeile im Kommentar',
PRIMARY KEY (def_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 comment 'erste Zeile Tabellenkommentar
zweite Zeile Tabellenkommentar
dritte Zeile Tabellenkommentar'

Adminer don't show the newline - see screenshot "adminer_table_description.png".

SchemaSpy (database documentation tool) show the newlines - see screenshot "schemaspy_table_description".

I would be glad if adminer the newlines can also use.

Kind regards,
kbudde

2 Attachments

Discussion

  • Jakub Vrána

    Jakub Vrána - 2018-01-22
    • status: open --> closed-fixed
     
  • Jakub Vrána

    Jakub Vrána - 2018-01-22

    Adminer doesn't support editing comments with newlines but it at least displays them now.

     

Log in to post a comment.