dbTalk Databases Forums  

how to have an case insensitive db server or database?

microsoft.public.sqlserver.mseq microsoft.public.sqlserver.mseq


Discuss how to have an case insensitive db server or database? in the microsoft.public.sqlserver.mseq forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Alice
 
Posts: n/a

Default how to have an case insensitive db server or database? - 09-03-2003 , 05:43 PM






I need to have a database server to be case in-sensitive,
how can I do it?

Thank you,
Alice

Reply With Quote
  #2  
Old   
Vishal Parkar
 
Posts: n/a

Default Re: how to have an case insensitive db server or database? - 09-04-2003 , 01:10 AM






choose server coallation as sql_latin1_general_cp1_CI_AS, which is the
default collation for sql server.
you can also specify the collation at database level while creating the
database.

--
-Vishal
Alice <gth (AT) hotmail (DOT) com> wrote

Quote:
I need to have a database server to be case in-sensitive,
how can I do it?

Thank you,
Alice



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.