dbeaver/dbeaver

Multiple-line values in Query Results

Open

#2,192 opened on 2017年9月21日

GitHub で見る
 (4 comments) (1 reaction) (0 assignees)Java (4,178 forks)batch import
help wantedxf:dataxf:data editor

Repository metrics

Stars
 (50,035 stars)
PR merge metrics
 (平均マージ 19d 10h) (30d で 105 merged PRs)

説明

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.                                                                  +

コントリビューターガイド