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

SQL Server 2005 Case Sensitivity Expand / Collapse
Author
Message
Posted Friday, August 29, 2008 2:31 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 5, 2013 7:41 AM
Points: 1,146, Visits: 230
Any of you have any idea why SQL Server 2005 is having CASE Senstive Schemaname.tablename collection.
Let say i am having Schema Person in which i am having table Contact,
then person.contact will never work, you will have to enter it as according to you declared Person.Contact. (with a default installation)


Regards,
Manoj



Post #561046
Posted Friday, August 29, 2008 2:57 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 4:53 AM
Points: 2,366, Visits: 1,844
Hi

Check the collation of your server and database.


"Keep Trying"
Post #561055
Posted Friday, August 29, 2008 4:11 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 5, 2013 7:41 AM
Points: 1,146, Visits: 230
Thanks for reply chirag.
I have used the word "default" in the question.

Regards
Manoj



Post #561083
Posted Thursday, September 4, 2008 6:43 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 10, 2013 4:59 PM
Points: 79, Visits: 183
Sounds like SQL Server was setup with Binary Sort as the default collation. I would also bet that all your column names, table names, etc are case sensitive as well. Also, all queries that use the default sort would also be case sensitive.

Binary Sort is a pain until you get used to it. Then it just becomes second nature. :)



Gary Johnson
Sr Database Engineer
Post #564276
Posted Friday, September 5, 2008 4:27 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 5, 2013 7:41 AM
Points: 1,146, Visits: 230
i mean to say comparing with SQL 2000
selecting serverproparty('collation') will return defaulr SQL_Latin1_General_CP1_CI_AS (if i am not wrong).
but As 2005 introduce Schema feature which becomes
Case-Sensitive combination of schema and tablename.
which becomes more tedious job then earlier.

Regards
Manoj



Post #564437
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse