dbeaver / dbeaver/dbeaver

DBeaver FR: Add display of SQL Server BIT columns as checkboxes in data grid

Open
#7,806 3 comments 0 reactions 0 assignees View on GitHub
enhancement
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 8h
Merged PRs (30d)
188

Description

DBeaver - **Version 6.3.4 CE EA**
DBeaver driver: **MS SQL Server / Microsoft Driver** _(the new Microsoft Driver)_
Operating System: **Windows 7 / Windows 8.1 / Windows 10**
Database Server: **Microsoft SQL Express 2014, 2016, 2017**

It would be great if the system setting below made SQL Server **BIT** column values presented as checkboxes instead of just **1** or **0** (and **NULL**).

Currently the system setting has no effect on the display in the result grids.

**Run the SQL script below**
```
CREATE TABLE TestBoolean (Id INTEGER, Flag BIT, Message TEXT);
GO

INSERT INTO TestBoolean VALUES (1, 'True', 'My Message');
GO

SELECT * FROM TestBoolean;
```

**It result into (either way the system setting value)**
```
Id Flag Message
1 1 My Message
```

**SystemSetting**:

The system setting in questing is:

  **DBeaver** -> **Editors** -> **Data Editor** -> **Presentation** -> **Grid** -> **Show booleans as checkboxes**.

**PS**. This issue label can be changed from bug to feature request. Seems I can't change it myself after the issue is created.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.