有区分大小写的数据库有好处吗？ [英] Are there benefits to a case sensitive database?

问题描述

我们刚刚将SQL Server 2005数据库从DEVEL迁移到TEST。不知何故，在迁移过程中，数据库从不区分大小写的敏感的更改，所以大多数SQL查询爆炸。

我想知道，是 - 有任何明确有利于具有区分大小写的模式？

注意：我的意思是表名，列名，存储过程名等。我不是指存储在表中的实际数据。

解决方案

在第一次检查时，我找不到有效的原因，

我刚刚发现为什么我们使它区分大小写。这是为了确保当我们在客户端站点上部署它时，无论客户端的SQL Server是否设置区分大小写，我们的DB都能工作。

这是一个答案我没想到。

We have just 'migrated' an SQL Server 2005 database from DEVEL into TEST. Somehow during the migration process the DB was changed from case insensitive to sensitive - so most SQL queries broke spectacularly.

What I would like to know, is - are there any clear benefits to having a case sensitive schema?

NOTE: By this I mean table names, column names, stored proc names etc. I am NOT referring to the actually data being stored in the tables.

At first inspection, I cannot find a valid reason that offers benefits over case insensitivity.

解决方案

I just found out why WE make it case sensitive. It is to ensure that when we deploy it on the client site, our DB works regardless whether the client's SQL Server is set up case sensitive or not.

That is one answer I wasn't expecting.

这篇关于有区分大小写的数据库有好处吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！