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

[EngTurtle]

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

Results in the following table after saving, where the Name column has length 1

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

• I tried with a new QGIS profile

Additional context

No response