Oracle Data是否区分大小写? [英] Is Oracle Data Casesensitive?

问题描述

Oracle数据是否区分大小写?
如果是的话..
那么我如何才能消除此数据区分大小写的问题..

Is Oracle Data Casesensitive?
if yes..
then how i can remove this data case sensitivity..??

推荐答案

请参考以下链接的类似讨论，您肯定会从中得到一些帮助. /> 不区分大小写的数据库 [使Oracle大小写不​​敏感 [

Please refer similar discussion on following link, you will sure get some needful from it..
Case insensitive database[^]

Also have look on this article:
Making Oracle Case insensitive[^]

设置oracle参数如

NLS_COMP = LINGUISTIC和
NLS_SORT = BINARY_CI

对于不区分大小写的数据.

仅用于会话..在查询下运行

ALTER SESSION SET NLS_COMP =语言;
ALTER SESSION SET NLS_SORT = BINARY_CI;

set oracle parameter as

NLS_COMP=LINGUISTIC and
NLS_SORT=BINARY_CI

for data incasesensitive.

for session only..run below query

ALTER SESSION SET NLS_COMP=LINGUISTIC;
ALTER SESSION SET NLS_SORT=BINARY_CI;

这篇关于Oracle Data是否区分大小写?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！