# Source: https://dbeaver.com/docs/dbeaver/Data-Editor-preferences/

Expand all

  * [ Getting started  ](..)

Getting started

    * [ First steps  ](../Getting-started/)
    * [ Installation  ](../Installation/)
    * [ Application window overview  ](../Application-Window-Overview/)
    * [ Basic operations  ](../Basic-operations/)
  * DBeaver configuration  DBeaver configuration 
    * [ User interface  ](../User-Interface-Themes/)
    * [ Interface language  ](../UI-Language/)
    * [ Accessibility  ](../Accessibility-Guide/)
    * [ Toolbar customization  ](../Toolbar-Customization/)
    * [ Database object editor  ](../Database-Object-Editor/)
    * [ Reset UI settings  ](../Reset-UI-settings/)
    * [ Shortcuts  ](../Shortcuts/)
  * Security  Security 
    * [ Security in DBeaver PRO  ](../Security-in-DBeaver-PRO/)
    * Password secure storage  Password secure storage 
      * [ Secure storage  ](../Security/)
      * [ Master password  ](../Managing-Master-Password/)
      * [ Automation (console) security  ](../Automation-Security/)
      * [ Integrated security  ](../Integrated-Security/)
    * [ Secret Management  ](../Secret-Providers/)
  * Configure connection  Configure connection 
    * Connection settings  Connection settings 
      * [ Create connection  ](../Create-Connection/)
      * [ Edit connection  ](../Edit-Connection/)
      * [ Invalidate and reconnect  ](../Invalidate-and-Reconnect-to-Database/)
      * [ Disconnect from database  ](../Disconnect-from-Database/)
      * [ Change current user password  ](../Change-current-user-password/)
      * [ Shell commands  ](../Working-with-Shell-Commands-in-DBeaver/)
      * [ Initialization settings  ](../Configure-Connection-Initialization-Settings/)
      * [ Security restrictions for database connection  ](../Managing-security-restrictions-for-database-connection/)
      * [ Connection types  ](../Connection-Types/)
      * [ Local client configuration  ](../Local-Client-Configuration/)
      * [ Multiple datasource connections  ](../Separate-Connections/)
    * Network configuration  Network configuration 
      * [ Network configuration  ](../Network-configuration/)
      * Connection network options  Connection network options 
        * [ SSH configuration  ](../SSH-Configuration/)
        * SSL  SSL 
          * [ SSL configuration  ](../SSL-Configuration/)
          * Truststore management  Truststore management 
            * [ Manage certificates  ](../Managing-Truststore-Settings/)
            * [ Import custom certificates  ](../Import-SSL-Certificates/)
          * [ Oracle SSL configuration  ](../SSL-Configuration-Oracle/)
        * Proxy  Proxy 
          * [ Proxy configuration  ](../Proxy-configuration/)
          * [ Proxy configuration with system files  ](../Proxy-configuration-with-system-files/)
        * [ Kubernetes configuration  ](../Kubernetes-configuration/)
        * [ AWS SSM configuration  ](../AWS-SSM-Configuration/)
      * [ Network profiles  ](../Network-profiles/)
    * Transaction mode  Transaction mode 
      * [ Transaction log  ](../Transaction-Log/)
      * [ Pending transactions  ](../Pending-Transactions/)
      * [ Auto and manual commit modes  ](../Auto-and-Manual-Commit-Modes/)
    * Database authentication models  Database authentication models 
      * [ Database native  ](../Authentication-Database-Native/)
      * [ DBeaver profile  ](../Authentication-DBeaver-profile/)
      * [ Microsoft Entra ID  ](../Authentication-Microsoft-Entra-ID/)
      * [ Kerberos  ](../Kerberos-Authentication/)
    * Driver settings  Driver settings 
      * [ Driver manager  ](../Driver-Manager/)
      * [ ODBC & JDBC driver  ](../ODBC-JDBC-Driver/)
      * [ File-based driver properties  ](../File-based-driver-properties/)
      * [ How to add additional artifacts to the driver  ](../How-to-add-additional-artifacts-to-the-driver/)
      * [ JDBC time zones  ](../JDBC-Time-Zones/)
      * [ JDBC tracing  ](../JDBC-Tracing/)
      * [ Deprecated legacy ODBC driver  ](../Deprecated-legacy-ODBC-driver/)
  * Databases support  Databases support 
    * [ Database drivers  ](../Database-drivers/)
    * Classic  Classic 
      * [ Apache Hive  ](../Apache-Hive/)
      * [ Cassandra  ](../Cassandra/)
      * [ ClickHouse  ](../Clickhouse/)
      * [ Couchbase  ](../Couchbase/)
      * [ IBM Db2  ](../Database-driver-IBM-Db2/)
      * [ Greenplum  ](../Database-driver-Greenplum/)
      * [ InfluxDB  ](../InfluxDB/)
      * [ Microsoft SQL Server  ](../Database-driver-Microsoft-SQL-Server/)
      * [ MariaDB  ](../Database-driver-MariaDB/)
      * MongoDB  MongoDB 
        * [ MongoDB  ](../MongoDB/)
        * [ MongoDB authentication  ](../Authentication-MongoDB/)
      * MySQL  MySQL 
        * [ MySQL  ](../Database-driver-MySQL/)
        * [ Two-factor authentication  ](../Authentication-MySQL-Two-factor/)
      * [ Netezza  ](../Database-driver-Netezza/)
      * Oracle  Oracle 
        * [ Oracle  ](../Oracle/)
        * [ Oracle authentication  ](../Connecting-to-Oracle-databases/)
        * [ JDBC OCI driver  ](../Connecting-to-Oracle-Database-using-JDBC-OCI-driver/)
      * PostgreSQL  PostgreSQL 
        * [ PostgreSQL  ](../Database-driver-PostgreSQL/)
        * [ PgPass authentication  ](../Authentication-PostgreSQL-Pgpass/)
        * [ SSPI (Windows SSO)  ](../Authentication-PostgreSQL-SSPI/)
      * [ Redis  ](../Redis/)
      * Salesforce  Salesforce 
        * [ Salesforce  ](../Database-driver-Salesforce/)
        * [ Salesforce authentication  ](../Authentication-Salesforce/)
      * Teradata  Teradata 
        * [ Teradata  ](../Database-driver-Teradata/)
        * [ LDAP authentication in Teradata  ](../Authentication-LDAP-Mechanism/)
      * [ Trino  ](../Database-driver-Trino/)
      * [ Yellowbrick  ](../Database-driver-Yellowbrick/)
    * Cloud  Cloud 
      * AWS  AWS 
        * [ Athena  ](../Database-driver-Amazon-Athena/)
        * [ Aurora DSQL  ](../Database-driver-Aurora-DSQL/)
        * [ DocumentDB  ](../AWS-DocumentDB/)
        * [ DynamoDB  ](../AWS-DynamoDB/)
        * [ Keyspaces  ](../AWS-Keyspaces/)
        * [ Neptune  ](../Database-driver-Neptune/)
        * [ Redshift  ](../Database-driver-Amazon-Redshift/)
        * [ Timestream  ](../Database-driver-Amazon-Timestream/)
      * Azure  Azure 
        * [ Cosmos DB  ](../Database-driver-CosmosDB/)
        * [ Cosmos DB for NoSQL  ](../Database-driver-Azure-CosmosDB-for-NoSQL/)
      * Google  Google 
        * [ AlloyDB for PostgreSQL  ](../Database-driver-AlloyDB-for-PostgreSQL/)
        * [ BigQuery  ](../Database-driver-BigQuery/)
        * [ Bigtable  ](../Google-Bigtable/)
        * [ Cloud SQL for MySQL  ](../Database-driver-MySQL-on-Google-Cloud/)
        * [ Cloud SQL for PostgreSQL  ](../Database-driver-PostgreSQL-on-Google-Cloud/)
        * [ Cloud SQL for SQL Server  ](../Database-driver-Microsoft-SQL-Server-on-Google-Cloud/)
        * [ Firestore  ](../Database-driver-Firestore/)
        * [ Spanner  ](../Database-driver-Google-Cloud-Spanner/)
      * Databricks  Databricks 
        * [ Databricks  ](../Database-driver-Databricks/)
        * [ Databricks authentication  ](../Authentication-Databricks/)
      * Snowflake  Snowflake 
        * [ Snowflake  ](../Snowflake/)
        * [ Snowflake authentication  ](../Authentication-Snowflake/)
    * Embedded  Embedded 
      * [ SQLite  ](../Database-driver-SQLite/)
    * File drivers  File drivers 
      * [ Multi source  ](../Database-driver-Files-MultiSource/)
      * [ CSV  ](../Database-driver-CSV/)
      * [ JSON  ](../Database-driver-JSON/)
      * [ Parquet  ](../Database-driver-Parquet/)
      * [ XLSX  ](../Database-driver-XLSX/)
      * [ XML  ](../Database-driver-XML/)
    * Graph  Graph 
      * [ Neo4j  ](../Database-driver-Neo4j/)
  * Navigation  Navigation 
    * Database Navigator  Database Navigator 
      * [ Database Navigator  ](../Database-Navigator/)
      * [ Simple and advanced view  ](../Simple-and-Advanced-View/)
      * [ Configuring filters  ](../Configure-Filters/)
      * [ Filter database objects  ](../Filter-Database-Objects/)
      * [ Bookmarks  ](../Bookmarks/)
    * Projects  Projects 
      * [ Projects  ](../Projects/)
      * [ Projects view  ](../Projects-View/)
      * [ Project security  ](../Project-security/)
      * [ Project explorer  ](../Project-Explorer/)
    * Search  Search 
      * [ Search  ](../Search-Tool/)
      * [ Data search  ](../Data-Search/)
      * [ Full-text search database  ](../DB-Full-Text-Search/)
      * [ Metadata search  ](../DB-Metadata-Search/)
      * [ File search  ](../File-Search/)
  * [ Properties Editor  ](../Properties-Editor/)
  * Data Editor  Data Editor 
    * [ Data Editor  ](../Data-Editor/)
    * Viewing and editing data  Viewing and editing data 
      * [ Data view and format  ](../Data-View-and-Format/)
      * [ Data filters  ](../Data-Filters/)
      * [ Data viewing and editing  ](../Data-Viewing-and-Editing/)
      * [ Data refresh  ](../Data-Refresh/)
      * [ Result set navigation  ](../Navigation/)
      * Panels  Panels 
        * [ Panels  ](../Panels/)
        * [ Value Panel  ](../Value-Panel/)
        * [ References Panel  ](../References-Panel/)
        * [ Metadata Panel  ](../Metadata-Panel/)
        * [ Grouping Panel  ](../Grouping-Panel/)
        * [ Calc Panel  ](../Calc-Panel/)
        * [ Result details Panel  ](../Result-Details-Panel/)
        * [ Query trace Panel  ](../Query-Trace-Panel/)
      * [ Managing charts  ](../Managing-Charts/)
      * [ Mock data generation  ](../Mock-Data-Generation-in-DBeaver/)
      * [ Dashboards  ](../Dashboards/)
    * [ XML and JSON data  ](../Working-with-XML-and-JSON/)
    * [ Dictionary data  ](../Working-with-Dictionary-Data/)
    * [ Spatial GIS data  ](../Working-with-Spatial-GIS-data/)
    * Virtual entities  Virtual entities 
      * [ Virtual columns  ](../Virtual-column-expressions/)
      * [ Virtual keys  ](../Virtual-Keys/)
    * Data Editor preferences  [ Data Editor preferences  ](./) Table of contents 
      * Appearance 
        * Grid 
          * Grid appearance 
          * Grid behavior 
        * JSON 
        * Plain text 
      * Binary editor 
      * Data formats 
      * Dictionaries 
      * GIS viewer 
    * [ Data format preferences  ](../Managing-Data-Formats/)
  * SQL Editor  SQL Editor 
    * [ SQL Editor  ](../SQL-Editor/)
    * [ Visual query builder  ](../Visual-Query-Builder/)
    * Query execution  Query execution 
      * [ SQL execution  ](../SQL-Execution/)
      * [ Query execution plan  ](../Query-Execution-Plan/)
      * [ Script management  ](../Script-Management/)
    * Query development and assistance  Query development and assistance 
      * [ SQL Assist and Auto Complete  ](../SQL-Assist-and-Auto-Complete/)
      * [ SQL templates  ](../SQL-Templates/)
      * [ SQL query formatter  ](../SQL-Formatting/)
      * [ Variables panel  ](../Variables-panel/)
      * [ Spelling  ](../Spelling/)
    * [ SQL generation  ](../SQL-Generation/)
    * [ SQL terminal  ](../SQL-Terminal/)
    * Client side commands  Client side commands 
      * [ Client side scripting  ](../Client-Side-Scripting/)
      * [ Export command  ](../Export-Command/)
    * [ Query manager  ](../Query-Manager/)
    * [ SQL code Editor  ](../SQL-Code-Editor/)
    * [ SQL Plus script execution  ](../SQL-Plus-Script-Execution/)
    * [ PostgreSQL Arrays  ](../PostgreSQL-Arrays/)
    * [ PostgreSQL Extensions  ](../PostgreSQL-Extensions/)
  * Entity relation diagrams  Entity relation diagrams 
    * [ ER Diagrams  ](../ER-Diagrams/)
    * [ Database structure diagrams  ](../Database-Structure-Diagrams/)
    * [ Custom diagrams  ](../Custom-Diagrams/)
    * [ Edit mode for diagrams  ](../Edit-mode/)
  * Cloud services  Cloud services 
    * Cloud explorer  Cloud explorer 
      * [ Cloud explorer  ](../Cloud-Explorer/)
      * [ AWS cloud explorer  ](../AWS-Cloud-Explorer/)
      * [ Azure cloud explorer  ](../Azure-Cloud-Explorer/)
      * [ Google cloud explorer  ](../Google-Cloud-Explorer/)
    * [ Cloud storage  ](../Cloud-Storage/)
    * Cloud connection settings  Cloud connection settings 
      * AWS  AWS 
        * [ AWS permissions  ](../AWS-Permissions/)
        * [ AWS SSO  ](../AWS-SSO/)
        * [ AWS credentials  ](../AWS-Credentials/)
      * Azure  Azure 
        * [ Azure permissions  ](../Azure-Permissions/)
      * Google Cloud  Google Cloud 
        * [ Google Cloud SSO  ](../GCP-SSO/)
        * [ Google Cloud credentials  ](../GCP-Credentials/)
  * AI  AI 
    * [ AI Assistant  ](../AI-Smart-Assistance/)
    * [ Data privacy  ](../AI-Assistance-and-Data-Privacy/)
    * Features  Features 
      * AI chat  AI chat 
        * [ AI chat  ](../AI-chat/)
        * [ Speech recognition  ](../AI-speech-recognition/)
      * AI functions  AI functions 
        * [ AI functions  ](../AI-Functions/)
        * [ Data transfer actions  ](../Data-Transfer-Actions/)
        * [ Advanced metadata actions  ](../Advanced-Metadata-Read-Actions/)
        * [ View and editor actions  ](../View-and-Editor-Actions/)
      * Work with SQL  Work with SQL 
        * [ Query suggestion  ](../AI-query-suggestion/)
        * [ Explain query  ](../AI-query-explanation/)
        * [ Fix SQL errors  ](../AI-error-explanation/)
        * [ AI command  ](../AI-command/)
      * Work with objects  Work with objects 
        * [ Describe object with AI  ](../AI-smart-metadata-description/)
    * Tutorials  Tutorials 
      * [ Quick start with AI  ](../Quick-start-with-AI-Assistance/)
    * Settings  Settings 
      * [ AI Assistant settings  ](../AI-Assistance-settings/)
      * Providers  Providers 
        * [ OpenAI  ](../AI-integration-with-OpenAI/)
        * [ GitHub Copilot  ](../AI-integration-with-GitHub-Copilot/)
        * [ Azure OpenAI  ](../AI-integration-with-Azure-OpenAI/)
        * [ Google Gemini  ](../AI-integration-with-Google-Gemini/)
        * [ Ollama  ](../AI-integration-with-Ollama/)
        * [ Anthropic Claude  ](../AI-integration-with-Anthropic-Claude/)
        * [ Amazon Bedrock  ](../AI-integration-with-Amazon-Bedrock/)
      * [ Disable AI Assistant  ](../Disable-AI-assistance/)
  * Data transfer and schema compare  Data transfer and schema compare 
    * Data transfer  Data transfer 
      * [ Data transfer  ](../Data-transfer/)
      * [ Data import  ](../Data-import/)
      * [ Data import and replace  ](../Data-Import-and-Replace/)
      * [ Data export  ](../Data-export/)
      * [ Data transfer external storage  ](../Data-transfer-external-storage/)
      * [ Data migration  ](../Data-migration/)
      * [ Data transfer via email  ](../Data-transfer-email/)
    * [ Data compare  ](../Data-compare/)
    * [ Backup and restore  ](../Backup-Restore/)
    * Schema compare  Schema compare 
      * [ Schema compare  ](../Schema-compare/)
      * [ Liquibase support  ](../Using-Liquibase-in-DBeaver/)
  * Tasks  Tasks 
    * [ Task management  ](../Task-Management/)
    * [ Task scheduler  ](../Task-Scheduler/)
    * [ Composite tasks  ](../Composite-Tasks/)
  * Integrated tools  Integrated tools 
    * [ GIT integration  ](../Project-team-work/)
    * [ Tableau integration  ](../Tableau-integration-in-DBeaver/)
    * [ Database debugger (PostgreSQL)  ](../PGDebugger/)
    * [ Session Manager  ](../Session-Manager-Guide/)
    * [ Lock Manager  ](../Lock-Manager/)
    * [ Eclipse extensions  ](../Eclipse-extensions/)
  * Tutorials  Tutorials 
    * Table Creation  Table Creation 
      * [ New table creation  ](../New-Table-Creation/)
      * [ Incorporating triggers  ](../Incorporating-Triggers/)
      * [ Creating columns  ](../Creating-columns/)
      * [ Creating indexes  ](../Creating-Indexes/)
      * [ Implementing constraints  ](../Implementing-Constraints/)
      * [ Utilizing foreign keys  ](../Utilizing-Foreign-Keys/)
    * [ Sample database  ](../Sample-Database/)
    * [ Database partitions  ](../How-to-work-with-database-Partitions/)
    * [ Import connections from external tools  ](../How-to-import-Connections-from-External-Tools/)
  * Administration  Administration 
    * Admin preferences  Admin preferences 
      * [ Admin manage preferences  ](../Admin-Manage-Preferences/)
      * [ Admin manage drivers  ](../Admin-Manage-Drivers/)
      * [ Admin preference restrictions  ](../Admin-Preference-Restrictions/)
      * [ Admin variables  ](../Admin-Variables/)
    * General configuration  General configuration 
      * [ Configuration files  ](../Configuration-files-in-DBeaver/)
      * [ Pre-configured database connections  ](../Admin-Manage-Connections/)
      * [ Pre-configured variables  ](../Pre-configured-Variables/)
      * [ How to set a variable if dbeaver.ini is read only  ](../How-to-set-a-variable-if-dbeaver-ini-is-read-only/)
      * [ Command line  ](../Command-Line/)
      * [ Error log  ](../Log-files/)
      * [ Background tasks  ](../Background-Tasks/)
      * [ Workspace location  ](../Workspace-Location/)
      * [ Resetting your workspace  ](../Reset-workspace/)
      * [ Importing CA certificates from your local Java into DBeaver  ](../Importing-CA-certificates-from-your-local-Java-into-DBeaver/)
    * Troubleshooting  Troubleshooting 
      * [ Troubleshooting system issues  ](../Troubleshooting-system-issues/)
      * [ Troubleshooting task scheduler issues  ](../Troubleshooting-task-scheduler-issues/)
      * [ Making a thread dump  ](../Making-a-thread-dump/)
      * [ Posting issues  ](../Posting-issues/)
    * [ Windows silent install  ](../Windows-Silent-Install/)
    * [ Snap installation  ](../Snap-installation/)
  * Licenses  Licenses 
    * [ Import license  ](../How-to-Import-License/)
    * [ Update license  ](../How-to-Update-License/)
    * [ Reassign license  ](../How-to-Reassign-License/)
    * [ License administration  ](../License-Administration/)
    * License types  License types 
      * [ License types  ](../Differences-between-license-types/)
      * [ Early Access Program (EAP) license  ](../Early-Access-Program-license/)
  * About DBeaver  About DBeaver 
    * Editions  Editions 
      * [ Enterprise edition  ](../Enterprise-Edition/)
      * [ Lite edition  ](../Lite-Edition/)
      * [ Ultimate edition  ](../Ultimate-Edition/)
    * [ Release cycles  ](../DBeaver-release-cycles/)
    * [ Statistics collection  ](../Statistics-Collection/)
    * [ Customer technical support  ](../Customer-technical-support-information/)
  * [ FAQ  ](../FAQ/)

Table of contents

  * Appearance 
    * Grid 
      * Grid appearance 
      * Grid behavior 
    * JSON 
    * Plain text 
  * Binary editor 
  * Data formats 
  * Dictionaries 
  * GIS viewer 

  1. [DBeaver](/docs/dbeaver)
  2. Data Editor

# Data Editor preferences

You can fully customize how data is displayed and edited in the [Data
Editor](../Data-Editor/).

Use these settings to change the appearance, behavior, formatting, and
handling of different data types.

Tip

You can configure Data Editor preferences directly in the configuration file,
without starting the application. For details, see [how to manage preferences
via config files](../Admin-Manage-Preferences/).

All preferences are available at **Window - > Preferences -> Editors -> Data
Editor**.

Customize general behavior of the Data Editor::

Setting | Description  
---|---  
ResultSet fetch size | Number of rows fetched from the database in one batch. Affects performance  
Auto-fetch next segment | Automatically loads the next data segment when the current one is fully processed or viewed  
Refresh data on next page reading | Refreshes the data when moving to the next page  
Use SQL to limit fetch size | Modifies the source SQL query to scroll through or limit results. This is typically achieved using the `LIMIT`/`OFFSET` SQL clause  
Automatic Row Count | Counts the number of rows only once when you first open the data viewer. It doesn't update automatically after that.  
Ordering mode | Specifies how sorting is applied to query results:  
\- `Adaptive` (default) chooses the best strategy depending on context;  
\- `Always on client` sorts data after it's fetched;  
\- `Always on server` enforces sorting in the SQL query  
Default ordering | Specifies the default ordering of records. By default, the ordering is not changed, and the result set is displayed in the order in which it was fetched. Otherwise, this option has no effect if the table doesn't have a primary key. Please note that setting this option may result in an additional query to the database because information about constraints is unavailable beforehand  
Query cancel timeout (ms) | Defines the duration (in `milliseconds`) the system waits before cancelling a non-responsive query  
Always use subselect for filters | Forces the usage of subqueries when applying filters to the data  
Use column names instead of column labels | Prioritizes column names over column labels when referencing data  
Use fetch-size | Overrides the default JDBC fetch size. This is an advanced option and should only be changed if you know how the driver handles data fetching.  
Use all table columns as a key upon saving | Forms a virtual composite key using all table columns for data saving. If set to `true`, this will determine the action taken if a key element is missing. If set to `false`, no action will be taken when a key element is missing  
Disable data editing | Prevents data modification when a primary key is absent. This setting defines the action taken when the assumed primary key is missing  
Keep open cursors in SQL editor | Closes the result set after a selection. To view a cursor column value, the option should be enabled  
Insert new rows after current | Places newly inserted rows immediately following the currently selected row  
Refresh after update | Automatically refreshes the data after making changes  
Use navigator filters | Employs filters in the navigator to refine the displayed data  
Activate advanced datetime editor | Enables the advanced datetime editor in the Data editor  
Show confirmation before save | Displays a prompt asking for a confirmation before saving changes  
Show errors in a dialog | Presents error messages in a separate dialog box  
Mark occurrences of the selected cell's value | Highlights instances of the selected cell's value within the data set  
Show images in web browser | Controls whether image data (e.g., PNG, JPEG stored as BLOBs) is displayed in the Value panel using an embedded browser. When disabled, images are shown as raw binary or hex.  
  
## Appearance¶

Customize how data looks in different modes.

Setting | Description  
---|---  
Switch to **Record** /**Grid** mode on single/multiple row(s) | Allow to switch between **Record mode** and **Grid mode** when dealing with single or multiple rows. When set to true, the system will automatically switch modes based on the number of rows selected (**Record mode** for a single row, **Grid mode** for multiple rows)  
Show filters panel in single tab mode | Shows the filters panel when using a single-tab layout in the Data Editor  
Show column description in header | Displays the description for each column in the header  
Calculate column width by cell values | Adjusts the width of each column based on the content of its cells  
Show connection name in status | Displays the name of the connection in the status section  
Visualize complex columns | Enables the visualization of complex columns (such as `objects`, `structures` and `arrays`)  
Right-justify numbers | Allows right-justify numbers  
Right-justify date/time values | Aligns date and time values to the right side of their respective cells or columns  
Enable auto-completion in data filter text | Activates the auto-completion feature in the data filter text field  
  
### Grid¶

Configure **Grid** view options.

#### Grid appearance¶

Setting | Description  
---|---  
Mark odd/even rows | Marks odd and even rows in the grid  
Colorize data types | Colorizes data types in the grid  
Show column type icons | Displays icons representing the data types of each column  
Show attribute filters | Enables the display of attribute filters in the grid  
Show attribute ordering | Shows asc/desc order icon in column header  
Show booleans as checkboxes | Represents boolean values in the grid as checkboxes  
Show whitespace characters | Displays whitespace characters within the grid  
Show column ordering | Shows column order in the column headers  
Value display format | Controls how values are shown in the Value panel:  
\- `Display (default)` shows formatted read-only values,  
\- `Editable` shows raw editable content  
\- `Database native` shows the exact value as stored in the database.  
Max auto size column % | Determines the maximum percentage of width a column can occupy  
  
#### Grid behavior¶

Setting | Description  
---|---  
Highlight rows with selected cells | Enables the highlighting of entire rows when one or more cells are selected  
Smooth scrolling | Enables smooth horizontal scrolling within the grid  
Toggle boolean on click | Allows boolean values to be toggled with a single click  
Select next cell after inline edit | After completing the inline edit, a cell on the next row will be selected, `SHIFT+ENTER` can be pressed to select the cell on the next column  
Double-click behavior | Defines the action taken when a cell is double-clicked (`None`, `Editor`, `Inline editor`, `Copy selected cell`, `Paste cell value into editor`)  
Row color batch size | Number of consequent rows with the same background color  
  
### JSON¶

Note

This feature is available in [Lite](../Lite-Edition/),
[Enterprise](../Enterprise-Edition/), [Ultimate](../Ultimate-Edition/) and
[Team](https://dbeaver.com/docs/team-edition/) editions only.

Collapse large `JSON` objects or `arrays` to simplify viewing.

Setting | Description  
---|---  
Collapse objects that have more members than | Specifies the max amount of object members before collapsing  
Collapse arrays that have more elements than | Determines the max amount of array element before collapsing  
Collapse objects that have deeper nesting than | Determines the max nesting of an object before collapsing  
  
Info

Read more on [working with JSON](../Working-with-XML-and-JSON/).

### Plain text¶

Adjust text data formatting.

Setting | Description  
---|---  
Tab size | Determines tab size  
Maximum column length | Determines the maximum length of a columnâs content  
Value display format | Controls how values are shown in the Value panel:  
\- `Display (default)` shows formatted read-only values,  
\- `Editable` shows raw editable content  
\- `Database native` shows the exact value as stored in the database.  
Show NULLs | Enables the display of `NULL`s  
Show line numbers | Enables the display of line numbers  
Leading delimiter | Enables trailing delimiter  
Trailing delimiter | Enables trailing delimiter  
Top delimiter | Enables top delimiter  
Bottom delimiter | Enables bottom delimiter  
Extra spaces | Enables extra spaces  
  
## Binary editor¶

Configure how binary and LOB data is handled.

Setting | Description  
---|---  
Open in separate editor | Opens separate string editor instead of dialog  
Binary data formatter | Determines the format in which binary data is displayed  
Binary editor | Enables to change the binary Data Editor (`EDITOR` or `PANEL`)  
Maximum length of binary strings | Determines the maximum length of binary strings  
Maximum LOB length to keep in memory | Determines the maximum length of `LOB` (Large Object) data that will be kept in memory  
String encoding | Allows to specify the character encoding used when interpreting binary data as strings  
Cache CLOB values | Enables caching of `CLOB` (Character Large Object) values to reduce repeated reads  
Cache BLOB values | Enables caching of `BLOB` (Binary Large Object) values for better performance  
LOB cache max size | Sets the maximum total size of cached `LOB` data  
Edit LONG columns as LOBs | Treats LONG column types (e.g. in Oracle) as `LOB`s for consistent editing  
Maximum text editor content length (`KB`) | Limits the size of LOB content (in `KB`) shown in the text editor  
Commit session on value edit apply | Automatically commits the transaction after applying edited scalar values  
Commit session on content edit apply | Automatically commits the transaction after editing and saving `LOB` or large content fields  
  
## Data formats¶

Change how numbers, dates, and times are formatted in the Data Editor.

Info

For details, see [Managing data formats](../Managing-Data-Formats/).

## Dictionaries¶

Define how DBeaver recognizes description columns.

Setting | Description  
---|---  
Keywords for dictionary description columns | Defines which column names are considered descriptive or label columns  
Maximum amount of elements on a dictionary panel page | Determines how many dictionary values are shown per page  
  
## GIS viewer¶

Adjust spatial data viewer settings.

Setting | Description  
---|---  
Default SRID | Sets the default spatial reference system (e.g. `4326`)  
Maximum objects per viewer | Limits how many spatial objects are shown at once  
Minimum zoom level | Prevents zooming too far out on spatial visualizations  
  
Back to top