dbeaver/dbeaver

Multiple-line values in Query Results

Open

#2,192 建立於 2017年9月21日

在 GitHub 查看
 (4 留言) (1 反應) (0 負責人)Java (4,178 fork)batch import
help wantedxf:dataxf:data editor

倉庫指標

Star
 (50,035 star)
PR 合併指標
 (平均合併 19天 10小時) (30 天內合併 105 個 PR)

描述

The Query Results Window in DBeaver is not formatting the fields that contains multiple lines. A character is displayed instead of having the next part of the text displayed on a different line.

Have tried going to "Preferences > Database > Result Sets > Binaries" in DBeaver and changing the "String encoding" from the default UTF-8 value.

The Query Results Window in DBeaver displays the character instead of going to the next line of text regardless of the DB connection type (PostgreSQL or Oracle).

Example:

  • DBeaver Version 4.2.1
  • PostgreSQL Version: 9.4.7

Here the text for the log_message field is displayed on one line with ¶ where it should go to the next line.


log_message                                                                                                                                                                                          
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Sep 10, 2017 1:57:36 AM - User Secondary Institution Role [create/update, 1......, STUDENT]¶Institution Role'STUDENT' applied to '1......' successfully.¶1......|STUDENT ¶Field mapping successful.¶ 

This is how the log_message field properly is displayed when connecting to the Postgres DB via the psql client and querying the respective table:

                                         log_message
---------------------------------------------------------------------------------------------
 Sep 10, 2017 1:57:36 AM - User Secondary Institution Role [create/update, 1......, STUDENT]+
 Institution Role'STUDENT' applied to '1......' successfully.                               +
 1......|STUDENT                                                                            +
 Field mapping successful.                                                                  +

貢獻者指南