Re: Collate: Case INsensitive dictionary object names, Case sensitive column values: How To?

bill (billmaclean1@xxxxxxxxx) writes:
Is there a collation page that will make SQL 2008 act the same way as
Oracle: e.g the dictionary object names are case INsensitive, but the
column values are case sensitive?

There is no way to specify different collations for data and metadata,
save by explicitly specifying the collation for all columns different
from the database collation.

However, I have a Connect suggestion that you can vote for:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackI
D=358312

Personally, I would like to do it the other way round. Object names should
be case-sensitive, period. However, users often prefer if their data is
case-insensitive.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

.

Relevant Pages

  • Collate: Case INsensitive dictionary object names, Case sensitive column values: How To?
    ... Is there a collation page that will make SQL 2008 act the same way as ... Oracle: e.g the dictionary object names are case INsensitive, ...
    (comp.databases.ms-sqlserver)
  • Re: Case sensitiveness in doing deletes and updates
    ... you can change the table definition to a different collation. ... Evidently Sql Server is case insensitive in regards ... statement to specify case-sensitivity without having to change anything ...
    (microsoft.public.sqlserver.tools)
  • Collation --- please help!
    ... scripts to customers wrt collation issues. ... which is the default for UK SQL ... The only reason they do specify ...
    (microsoft.public.sqlserver.programming)
  • RE: Install SQL Server 2000 with different COLLATION
    ... When you upgrade an existing SQL 7.0 instance, ... always inherits the 7.0 instance's collation. ... If you want to install SQL ... Microsoft SQL Server Support ...
    (microsoft.public.sqlserver.server)
  • Re: To unicode or not?
    ... Then again, since SQL Server stores Unicode data in the UCS-2 encoding, ... use them with varchar, you simply work with a subset of the characers, ... an SQL collation is just a Windows collation ...
    (comp.databases.ms-sqlserver)
Loading