Post reply

Finding the database collation

  • March 12, 2016 at 2:36 pm

    #75734

    Comments posted to this topic are about the item Finding the database collation

  • March 12, 2016 at 11:48 pm

    #1864780

    Good 2 know this, thanx 4 the question.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • March 13, 2016 at 3:11 am

    #1864783

    Good question, thanks.

    ...

  • March 14, 2016 at 12:26 am

    This was removed by the editor as SPAM

  • March 14, 2016 at 1:53 am

    #1864848

    1) and 4) are both right.

  • March 14, 2016 at 2:08 am

    This was removed by the editor as SPAM

  • March 14, 2016 at 2:12 am

    #1864850

    Stewart "Arturius" Campbell (3/14/2016)

    Mauricio_ (3/14/2016)

    1) and 4) are both right.

    SERVERPROPERTY('Collation') will return the server instance's collation, which may (and frequently does) differ from the database collation.

    Ahh, thanks for that, Stewart. In my case was exactly the same and that confused me.

  • March 14, 2016 at 5:40 am

    #1864874

    Mauricio_ (3/14/2016)

    Stewart "Arturius" Campbell (3/14/2016)

    Mauricio_ (3/14/2016)

    1) and 4) are both right.

    SERVERPROPERTY('Collation') will return the server instance's collation, which may (and frequently does) differ from the database collation.

    Ahh, thanks for that, Stewart. In my case was exactly the same and that confused me.

    I wanted to pick that one too, but I read the rest of the answers and then re-read the question. Almost. 😉

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • March 15, 2016 at 6:42 am

    #1865196

    Stewart "Arturius" Campbell (3/14/2016)

    Mauricio_ (3/14/2016)

    1) and 4) are both right.

    SERVERPROPERTY('Collation') will return the server instance's collation, which may (and frequently does) differ from the database collation.

    Good to know, thanks.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply