March 12, 2016 at 2:36 pm
Comments posted to this topic are about the item Finding the database collation
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
March 12, 2016 at 11:48 pm
Good 2 know this, thanx 4 the question.
March 13, 2016 at 3:11 am
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
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
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
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. 😉
March 15, 2016 at 6:42 am
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