dbeaver/dbeaver

Multiple-line values in Query Results

開放

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

 (4 則留言) (1 個反應) (0 位負責人)Java (4,178 個分叉)batch import
help wantedxf:dataxf:data editor

倉庫指標

星標
 (50,035 顆星)
PR 合併指標
 (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.                                                                  +

貢獻者指南