MSSQL migration Default values adds quotes

[ChrisSantiago82]

Laravel Version

12

PHP Version

8.3

Database Driver & Version

sqlsrv

Description

I have a project that was written for Mysql, now it was decided that it should run with an MSSQL Server.

The change was painless but one issue I can not get ressolved:

I have a migration that sets a default value to a field:
$table->string('currency', 6)->default('chf');

The issue is that the quotes are added to the default value.

So the default value is 'chf' and if I updated the field it's only chf without the quotes.

Steps To Reproduce

Create a migration, set a default value and run migration (on a MSSQL Database).

[crynobone]

Hey there, thanks for reporting this issue.

We'll need more info and/or code to debug this further. Can you please create a repository with the command below, commit the code that reproduces the issue as one separate commit on the main/master branch and share the repository here?

Please make sure that you have the latest version of the Laravel installer in order to run this command. Please also make sure you have both Git & the GitHub CLI tool properly set up.

laravel new bug-report --github="--public"

Do not amend and create a separate commit with your custom changes. After you've posted the repository, we'll try to reproduce the issue.

Thanks!

[ChrisSantiago82]

Sorry, this was a driver issue on my side.