search

rails-sqlserver / activerecord-sqlserver-adapter

SQL Server Adapter For Rails
MIT License
972 stars 558 forks source link

Ensure correct order of COLLATE and NOT NULL in CREATE TABLE statements #1145

Closed kiyot closed 8 months ago

kiyot commented 9 months ago

COLLATE must appear before NOT NULL for SQL Server

https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql

aidanharan commented 8 months ago

Thanks for the fix @kiyot. I just changed your PR slightly by combining the test case into an existing test file.