Cannot use on SQL Server

outl1ne / nova-settings

A Laravel Nova tool for editing custom settings using native Nova fields.

MIT License

273 stars 97 forks source link

Cannot use on SQL Server #51

Closed davidjosephhayes closed 3 years ago

davidjosephhayes commented 3 years ago

Issue

php artisan migrate fails on SQL Server due to column length constraints.

SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The size (8192) given to the column 'value' exceeds the maximum allowed for any data type (8000). (SQL: create table "nova_settings" ("key" nvarchar(255) not null, "value" nvarchar(8192) null))

Possible fix

Convert column from varchar/nvarchar to text.

Tarpsvo commented 3 years ago

Hi! I released the feature you requested and submitted a PR for in version 3.1.2. Good luck!

davidjosephhayes commented 3 years ago

Thank you!