Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Creating table on MSSQL sets varchar and nvarchar column lengths as 1 regardless of UI input #58809

Closed
1 of 2 tasks
EngTurtle opened this issue Sep 19, 2024 · 0 comments · Fixed by #58955
Closed
1 of 2 tasks

Creating table on MSSQL sets varchar and nvarchar column lengths as 1 regardless of UI input #58809

EngTurtle opened this issue Sep 19, 2024 · 0 comments · Fixed by #58955
Assignees
@elpaso
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! MS SQL data provider

Comments

@EngTurtle
Copy link

EngTurtle commented Sep 19, 2024 •
edited
Loading

What is the bug or the crash?

Creating a table on a MSSQL connection using the QGIS GUI results in NVARCHAR columns of length 1 instead of set value.

Steps to reproduce the issue

Creating a table on a MSSQL connection using the following input, where Name column is set with length 50
image
Results in the following table after saving, where the Name column has length 1
image

Versions

QGIS version 3.38.2-Grenoble installed via Chocolatey
SQL Server version 15.0.4312.2

Supported QGIS version

  • I'm running a supported QGIS version according to the roadmap.

New profile

Additional context

No response
@EngTurtle EngTurtle added the Bug Either a bug report, or a bug fix. Let's hope for the latter! label Sep 19, 2024
@elpaso elpaso self-assigned this Oct 3, 2024
elpaso added a commit to elpaso/QGIS that referenced this issue Oct 3, 2024
@elpaso
[mssql] Fix nvarchar length qgis#58809
3c9deaa
@elpaso elpaso mentioned this issue Oct 3, 2024
Merged
elpaso added a commit that referenced this issue Oct 3, 2024
@elpaso
Merge pull request #58955 from elpaso/bugfix-gh58809-mssql-nvarchar-l…
5c142d8 
…ength

[mssql] Fix nvarchar length #58809
elpaso added a commit to elpaso/QGIS that referenced this issue Oct 3, 2024
@elpaso
[mssql] Fix nvarchar length qgis#58809
fc353f4
nyalldawson pushed a commit that referenced this issue Oct 4, 2024
@elpaso @nyalldawson
[mssql] Fix nvarchar length #58809
b2a3278
nyalldawson pushed a commit that referenced this issue Oct 25, 2024
@elpaso @nyalldawson
[mssql] Fix nvarchar length #58809
722bb98
nyalldawson pushed a commit that referenced this issue Oct 25, 2024
@elpaso @nyalldawson
[mssql] Fix nvarchar length #58809
0ff4529
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@elpaso elpaso

Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! MS SQL data provider
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

[mssql] Fix nvarchar length #58809 elpaso/QGIS
3 participants
@elpaso @EngTurtle @agiudiceandrea