dbeaver / dbeaver/dbeaver

Auto-close issue with NVARCHAR strings in SQL Server

Open
#39,235 1 comment 0 reactions 0 assignees View on GitHub
x:mssql xf:sql editor
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 8h
Merged PRs (30d)
188

Description

### Description

When writing queries in SQL Server, I frequently use NVARCHAR strings that start with `N'`. However, after typing `N'`, the auto-close feature doesn't seem to work, as the second single quote doesn't appear automatically. As a result, I have to manually type the second single quote. Unfortunately, once I do that, the auto-close feature kicks in and adds a third single quote, resulting in `N'''`. This means I have to delete the extra single quote every time, which is quite cumbersome.
Is there a way to fix this issue or a setting that can make the auto-close feature work correctly after typing N'?
Thanks!

### DBeaver Version

Community Edition Version 25.2.0.202508311659 & Version 25.1.5.202508171444

### Operating System

Windows 11 Pro

### Database and driver

1. Database: SQL Server 2016
2. Driver: com.microsoft.sqlserver:mssql-jdbc:RELEASE[12.8.0.jre11]

### Steps to reproduce

![Image](https://github.com/user-attachments/assets/37cdb492-b8ab-48da-a31f-4725d3f2aa27)

### Additional context

_No response_

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.