SQL Server case sensitive database

[EvgeniaAilin]

Hi, I'm trying to work with SQLServer database created with collation SQL_Latin1_General_CP1_CS_AS (case sensitive).
While migration tables, I discovered that several migrator's queries fail. After some research I found that migrator for SQL Server uses names of System Views and their columns names sometimes in uppercase, sometimes in lowercase.

Example:
in function: func (m Migrator) HasColumn written:
"SELECT count(*) FROM INFORMATION_SCHEMA.columns WHERE table_catalog = ? AND table_name = ? AND column_name = ?"

After I change it to "SELECT count(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG = ? AND TABLE_NAME = ? AND COLUMN_NAME = ?" - this query works.

Does someone did test GORM for case sensitive collation (SQL Server)?

Appreciate your fast response.

[github-actions]

The issue has been automatically marked as stale as it missing playground pull request link, which is important to help others understand your issue effectively and make sure the issue hasn't been fixed on latest master, checkout https://github.com/go-gorm/playground for details. it will be closed in 30 days if no further activity occurs. if you are asking question, please use the Question template, most likely your question already answered https://github.com/go-gorm/gorm/issues or described in the document https://gorm.io ✨ Search Before Asking ✨

[a631807682]

That's exactly what it sounds like, would you be interested in creating a PR for it ?

[EvgeniaAilin]

That's exactly what it sounds like, would you be interested in creating a PR for it ?

Yes, I would like to create PR to fix issue with SQL Server case sensitive database. How can I do it? I'm new in GitHub and appreciate for any help.
I did changes in the file migrator.go in package sqlserver. Now I'm resting it on my SQLServer database before requesting PR.