Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by bitbucket » OUTPUT - 1
Add to briefcase
42 posts, Page 4 of 5
«««12345»»

OUTPUT - 1 Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
batgirl
Posted Wednesday, February 27, 2013 9:52 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: Friday, May 10, 2013 5:28 AM
Points: 826, Visits: 358
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
Revenant
Posted Wednesday, February 27, 2013 10:52 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: 2 days ago @ 11:46 AM
Points: 3,448, Visits: 2,522
Wow - what a nice question! Thanks, Ron!
Post #1424651
mickyT
Posted Wednesday, February 27, 2013 11:15 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, May 16, 2013 1:32 PM
Points: 294, Visits: 1,101
Thanks, nice question
Post #1424661
L' Eomot Inversé
Posted Wednesday, February 27, 2013 12:33 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:38 PM
Points: 7,077, Visits: 7,116
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
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)
Post #1424691
SQLRNNR
Posted Wednesday, February 27, 2013 12:46 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Thursday, May 16, 2013 1:46 PM
Points: 18,732, Visits: 12,329
Thanks for the question.


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

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
L' Eomot Inversé
Posted Wednesday, February 27, 2013 12:47 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:38 PM
Points: 7,077, Visits: 7,116
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
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)
Post #1424705
Momhammad Atif
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, May 12, 2013 11:37 PM
Points: 9, Visits: 68
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
pchirags
Posted Thursday, February 28, 2013 3:25 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 1:18 PM
Points: 1,214, Visits: 230
Awesome Question...
Thank You.
Post #1425304
Dineshbabu
Posted Monday, March 04, 2013 4:43 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:50 AM
Points: 746, Visits: 435
Interesting question.

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

--
Dineshbabu
Desire to learn new things..
Post #1426179
(Bob Brown)
Posted Tuesday, March 05, 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: Friday, April 19, 2013 10:27 AM
Points: 690, Visits: 1,100
Thanks! Good question.
Post #1426948
« Prev Topic | Next Topic »

Add to briefcase
42 posts, Page 4 of 5
«««12345»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.