我应该把我的数据库中的所有文本以大写还是小写？ [英] Should I store all the text in my database in uppercase or in lowercase?

问题描述

您希望在数据库中存储文本哪一个？原始套管的数据，或某种规范化。此外，我应该使用触发器执行此操作吗？或者我应该用客户端代码预处理输入数据？

Which one do you prefer to store text in your database? The original casing of the data, or some kind of normalization. Also, should I enforce this with triggers? or should I preprocess input data with client code?

我问你，因为我不确定是否有任何区别，除了额外的处理时间显示数据

I ask you, because I'm not sure about if there is any difference, besides additional processing time to display data (capitalization of names, for example).

推荐答案

以原始大小写存储，除非有其他原因。花费在增加或减少数据的时间可能非常小，你永远不知道什么时候你会想要真正的，原始的数据在未来。

Store in original case, unless there is a reason to do otherwise. The time spent to upper or lower case the data is likely very small, and you never know when you'll want the real, original data back in the future.

这篇关于我应该把我的数据库中的所有文本以大写还是小写？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！