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 «««12345»»

OUTPUT - 1 Expand / Collapse
Author
Message
Posted Wednesday, February 27, 2013 9:52 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 10:41 AM
Points: 1,377, Visits: 1,569
Many years ago I was working to support a SQL Server based accounting system and had a very troubling issue that was ultimately found to have been caused by case sensitivity.

I learned the hard way that it can matter
Post #1424623
Posted Wednesday, February 27, 2013 10:52 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, August 22, 2014 8:50 AM
Points: 4,425, Visits: 3,417
Wow - what a nice question! Thanks, Ron!
Post #1424651
Posted Wednesday, February 27, 2013 11:15 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 7:46 PM
Points: 997, Visits: 3,024
Thanks, nice question
Post #1424661
Posted Wednesday, February 27, 2013 12:33 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 5:34 PM
Points: 8,726, Visits: 9,277
Raghavendra Mudugal (2/27/2013)
actually... mine does. I am using the below version

Microsoft SQL Server 2012 - 11.0.2218.0 (X64) 
Jun 12 2012 13:05:25
Copyright (c) Microsoft Corporation
Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

and the model database's default collation is "Latin1_General_CI_AI" and when installing the sql express and under server configuration it was default selected
so i guess it mainly depends on what you select in the core setup, and Microsoft has made this as the default choice in the setup.

Interesting. I wonder if this is a new thing in SQL 2012, or maybe a difference between 32-bit and 64-bit - I'm still on 2008R2 32 bit and the default for both developer edition and express edition is CI_AS (although when I picked up the 2008R2 version of AdventureWorks it had a database collation Latin1_General_CI_AI). Or it may even be a difference between different countries.


Tom
Post #1424691
Posted Wednesday, February 27, 2013 12:46 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 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 #1424703
Posted Wednesday, February 27, 2013 12:47 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 5:34 PM
Points: 8,726, Visits: 9,277
batgirl (2/27/2013)
Many years ago I was working to support a SQL Server based accounting system and had a very troubling issue that was ultimately found to have been caused by case sensitivity.

I learned the hard way that it can matter

I learnt the hard way too: back in SQL 2000 days the default collation was one of the SQL collations (presumably at latin one, but I don't recall which) not a windows collation; but our code was all designed to work with Latin_General_CI_AS (except for bits designed to work with Arabic or other languages using non-Latin alphabets). The installation team managed, despite very clear instructions, to install servers at some customer sites with the default collation (and the wrong default language too, in many cases - they must have actively overridden the SQL server defaults there) and the resulting problems in getting the systems up and running correctly were pretty horrendous. Eventually the installation team was successfully educated, and it stopped happening, but while it was happening it made life very hard.


Tom
Post #1424705
Posted Thursday, February 28, 2013 3:36 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, July 13, 2014 1:22 PM
Points: 9, Visits: 79
Yes indeed nice question.

Ofcourse the answer depends on the collation of COL1 but if collation is not explicitly defined for COL1 during create statement then we need to assume that column is using the default collation of sql server database which is SQL_Latin1_General_CP1_CI_AS (Case Insensitive, Accent Sensitive)



Mohammad Atif
Email ID : mohammad.atif1987@gmail.com
Post #1424972
Posted Thursday, February 28, 2013 3:25 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, August 4, 2014 12:29 PM
Points: 1,812, Visits: 584
Awesome Question...
Thank You.
Post #1425304
Posted Monday, March 4, 2013 4:43 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, August 4, 2014 5:38 AM
Points: 945, Visits: 558
Interesting question.

I wonder why people thinking too complex(colation) for simple task.


--
Dineshbabu
Desire to learn new things..
Post #1426179
Posted Tuesday, March 5, 2013 11:13 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: Thursday, June 12, 2014 4:19 AM
Points: 701, Visits: 1,145
Thanks! Good question.
Post #1426948
« Prev Topic | Next Topic »

Add to briefcase «««12345»»

Permissions Expand / Collapse