Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Changing collations Expand / Collapse
Author
Message
Posted Wednesday, March 23, 2011 12:00 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Sunday, August 17, 2014 2:48 PM
Points: 3,352, Visits: 1,481
Comments posted to this topic are about the item Changing collations
Post #1082475
Posted Wednesday, March 23, 2011 1:12 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 16, 2014 9:38 AM
Points: 2,163, Visits: 2,189
Thanks for the question, I learned something. (However I hope I don't have to deal with multiple collations very often.)
Post #1082496
Posted Wednesday, March 23, 2011 2:01 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:23 AM
Points: 2,509, Visits: 2,386
In these days, I am changing collate on third party's database.
Post #1082514
Posted Wednesday, March 23, 2011 3:20 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 11:26 AM
Points: 13,622, Visits: 10,514
Nice question, thanks.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1082537
Posted Wednesday, March 23, 2011 3:25 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:24 AM
Points: 5,977, Visits: 8,239
Good question!

I missed it - I thought about potential blockers for changing collation of existing columns; I didn't stop to consider that ALTER DATABASE COLLATION doesn't affect those, but only the default setting. With that in mind, the correct answer is obvious.



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1082540
Posted Wednesday, March 23, 2011 6:21 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 5:52 PM
Points: 2,270, Visits: 3,789
This is a good question and definetly worth more than a point.

Mohammed Moinudheen
Post #1082629
Posted Wednesday, March 23, 2011 8:54 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 5:18 AM
Points: 3,925, Visits: 5,112
Good question
Had to reasearch it a bit. Learned something new.


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1082762
Posted Wednesday, March 23, 2011 9:20 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 11:26 AM
Points: 668, Visits: 485
Learned something new. Thanks for the question.
Post #1082779
Posted Wednesday, March 23, 2011 10:33 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, August 29, 2014 1:51 PM
Points: 21,644, Visits: 15,317
Thanks for the question.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1082830
Posted Wednesday, March 23, 2011 5:25 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, May 15, 2014 8:37 PM
Points: 589, Visits: 2,437
This one was a pretty hard one.
I never heard of "Collate" and I was converting "Collate" with "collation" wich mean "small lunch" in french... but I don't think that SQLserver needs to lunch any time so I had to search for what it means before, then find the microsoft site... then tried to understand it... then ... well, you know...I lost patience and answered the only one that looked logic to me, wich was wright, but not enough.

Finally, now that I have read the answer, I just realised that I loosed my patience only one paragraph before the answer!! Well... yup! I deserved loosing that point !

Thank you for the nice question. I learned two things today: the failing of a collate command and never loose patience

Post #1083048
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse