Post reply

CASE SENSITIVITY IN SQL SERVER 2005

  • July 29, 2008 at 12:04 pm

    #122612

    Is SQL server 2005 case sensitive? I discovered that the query below doesn't run

    USE AdventureWorks

    SELECT * FROM sales.salesorderheader

    GO

    until I rewrite it as

    USE AdventureWorks

    SELECT * FROM Sales.SalesOrderHeader

    GO

    Thanks for your prompt response.

    Regards,

    Sahoong.

  • July 29, 2008 at 12:35 pm

    #850058

    Check collation of this database.

    SELECT DATABASEPROPERTYEX('yourDB', 'collation')

  • July 29, 2008 at 2:30 pm

    #850137

    The 'strict' answer to your question is that SQL Server CAN be case sensitive, depending on the collation. Hence the above question. BOL will define the various collations possible and tell you which are case sensitive, which are not.

    Is this a 'curiousity' question, a potential problem, a real problem, or are you looking to prevent a problem because of case sensitivity?

  • July 29, 2008 at 4:12 pm

    #850185

    You can also collate tables and columns separately from the database.

  • July 29, 2008 at 4:46 pm

    #850203

    Thanks for your response. Could you please, give me the code that could be used for collating tables and colums separately? Many thanks. Regards, Sahoong.

  • July 29, 2008 at 4:47 pm

    #850204

    Thanks for this. It is very helpful.

  • July 29, 2008 at 4:48 pm

    #850205

    Many thanks. Its borne out of curiosity. Regards.

  • July 29, 2008 at 11:35 pm

    #850261

    How to change the collation of table and rows seperately???

  • July 30, 2008 at 4:21 am

    #850343

    Please check my blog for your reference,

    http://venkattechnicalblog.blogspot.com/2008/07/collation-in-sql-server.html

    Venkatesan Prabu .J

    Thanks and Regards,
    Venkatesan Prabu, 😛
    My Blog:

    http://venkattechnicalblog.blogspot.com/

  • July 30, 2008 at 7:53 am

    #850509

    Ratheesh.K.Nair (7/29/2008)

    How to change the collation of table and rows seperately???

    Please elaborate. change collation of table and rows separately from what? each other? or general, overall database?

    btw, I'm also curious about how to do this, other than the 'alter database' command, which has as its scope the entire db.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply