We help IT Professionals succeed at work.

sql server case sensitive

zolf
zolf asked
on
254 Views
Last Modified: 2013-11-23
hello there,

i created a db backup and created a new db with it.now when i use the db in my application i get db error.because the column names are capital in the db and in my java code it is small letter.is sql server sensitive to capital and small letter.also the query below gives me error Invalid object name 'bookht_user_session'.
UPDATE bookht_user_session SET logoff_time = GETDATE() WHERE session_id = 0

but when i change it to
UPDATE DOM.dbo.bookht_user_session SET logoff_time = GETDATE() WHERE session_id = 0
it works.
but in my old db i dont have these problem.i am using the same code but only the database is local now instead of remote.
Comment
Watch Question

Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:

can you please guide me remove case sensitivity in sql server 2005

Commented:
BOL is the best source:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/3242deef-6f5f-4051-a121-36b3b4da851d.htm
AneeshDatabase Consultant
CERTIFIED EXPERT
Top Expert 2009
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:

aneeshattingal:
thanks for your comment
>>try to change the collation of the db first
can you please guide me as i am new to sql server.
AneeshDatabase Consultant
CERTIFIED EXPERT
Top Expert 2009

Commented:
Did u check "DqMq"s comment

Author

Commented:

that link does not work

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/3242deef-6f5f-4051-a121-36b3b4da851d.htm

Author

Commented:

this is my db collation
SQL_Latin1_General_CP1_CS_AS

Author

Commented:

how do i change it to SQL_Latin1_General_CP1_CI_AI
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.