[Adminer4.7.7][MSSQL] No server default collation can be applied on table creation
Database management in a single PHP file
Brought to you by:
jakubvrana
Hi,
SQL server has its default collation set - which means that you don't need add parrameter "COLLATE" to "CREATE TABLE" command.
Problem is that default set (for me SQL_Latin1_General_CP1_CI_AS) cannot be specified as COLLATE parameter. (I think it may be bug in SQL server itself). Only way to set collation to SQL server default on table creation is to not include that parameter at all. Adminer cannot do this. In Adminer collation is mandatory parameter for all char/text fields.
In short words, what I guess supposed be done is:
Add default drop down option for MSSQL collation sellect, and if default is sellected, than whole parameter shouldnt be added to generated SQL command.
Regards :)
Albert
The table collation is not offered since dfd26d0.