Menu

#757 [Adminer4.7.7][MSSQL] No server default collation can be applied on table creation

Git
closed-works-for-me
nobody
None
5
2025-02-26
2020-07-07
AJas
No

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

Discussion

  • Jakub Vrána

    Jakub Vrána - 2025-02-26
    • status: open --> closed-works-for-me
     
  • Jakub Vrána

    Jakub Vrána - 2025-02-26

    The table collation is not offered since dfd26d0.

     

Log in to post a comment.

Auth0 Logo