Case Insensitive Oracle Query [英] Case Insensitive Oracle Query

问题描述

Hiya，


我正在查询我无法直接访问的Oracle数据库，因此无法更改服务器属性。

我需要对名称/或其他变量进行不区分大小写的搜索（C＃代码）

即.....


SELECT Field1，FIeld2 FROM TableName WHERE（Field1 =''" + Session [" Variable"]。ToString（）+"''" ;;


如果会话变量是Debbie

它会带回DEBBIE，debbie，DeBbIe等。


任何人都可以帮忙吗？
非常感谢。

Debs

解决方案

Hiya，


我正在查询我无法直接访问的Oracle数据库，因此无法更改服务器属性。

我需要对名称进行不区分大小写的搜索/或其他变量（C＃代码）

ie .....


" SELECT Field1，FIeld2 FROM TableName WHERE（Field1 =''" +会话[" Variable"]。ToString（）+"''" ;;


如果会话变量iable是Debbie

它会带回DEBBIE，debbie，DeBbIe等。


有人可以帮忙吗？

非常感谢。

Debs

你可以在=符号的两边上调以避免大小写差异。

您可以对=符号的两边进行UPPER以避免大小写差异。

你能给我一个例子，因为我确定我试过了吗

感谢Debs

< blockquote>

你能给我一个例子，因为我确定我试过了这个

感谢Debs

问题可能是我需要将它与LIKE一起使用; o（


ie

SELECT Field1，FIeld2 FROM TableName WHERE （Field1 LIKE''" + Session [" Variable"]。ToString（）+"''" ;;

这可能吗？

谢谢

Debs

Hiya,

I am querying an Oracle database that I have no direct access to so cannot change server properties.
I need to do a case insensitive search on a name/or other variable (C# code)
i.e .....

"SELECT Field1, FIeld2 FROM TableName WHERE (Field1=''" + Session["Variable"].ToString() + "''";

so that if the session variable was "Debbie"
it would bring back DEBBIE, debbie, DeBbIe etc.

Can anyone help?
thanks so much.
Debs

解决方案

Hiya,

I am querying an Oracle database that I have no direct access to so cannot change server properties.
I need to do a case insensitive search on a name/or other variable (C# code)
i.e .....

"SELECT Field1, FIeld2 FROM TableName WHERE (Field1=''" + Session["Variable"].ToString() + "''";

so that if the session variable was "Debbie"
it would bring back DEBBIE, debbie, DeBbIe etc.

Can anyone help?
thanks so much.
Debs

You can UPPER both sides of the = sign to avoid case diffrences.

You can UPPER both sides of the = sign to avoid case diffrences.

could you give me an example because I ''m sure I tried that
thanks Debs

could you give me an example because I ''m sure I tried that
thanks Debs

The problem could be that I need to use it in conjunction with LIKE ;o(

i.e
SELECT Field1, FIeld2 FROM TableName WHERE (Field1 LIKE ''" + Session["Variable"].ToString() + "''";
Is that possible?
Thanks
Debs

这篇关于Case Insensitive Oracle Query的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！