Forum Discussion

datswd's avatar
datswd
Copper Contributor
Feb 13, 2020

SQL Server collation setting

Hi everybody.

Could you please describe, why when i change collation setting of database from case sensetive to case insensetive it has influence on both data and SQL code.
May be there is some feature behind it?

Thanks in advance.

Regards,
Daniil.
  • SparrowDev's avatar
    SparrowDev
    Copper Contributor
    Feb 14, 2020

    datswdHi!

    I think when you change database collation it affects on all data is stored to this db and also on metadata, so you queris becomes case-sensitive or case-insensitive.

     


    Thanks in advance.

    Regards,
    Artem.

    • datswd's avatar
      datswd
      Copper Contributor
      Feb 14, 2020

      SparrowDev, correct.

      But why does this setting apply on both data and SQL code? Why there aren't two settings? One for data and another for SQL Code?

       

      I believe there is some useful feature behind it.

       

      SQL Server support team, could you please reveal this feature?

       

      Thanks in advance.

      Regards,

      Daniil.

  • datswd's avatar
    datswd
    Copper Contributor
    Feb 23, 2020

    455 views and no reply?

     

    MS Team, could you please clarify it? It would be great!

     

    Thanks in advance,

     

    Regards,

    Daniil.

Resources