case insensitive searching
Posted: Fri 12 Sep 2008 14:25
Hi
Oracle 10g, C# 3.5
I'm trying to set case insensitive searches base on what I have found on the web and tested in toad:
_command = new OracleCommand("", _connection);
_command.CommandText = "alter session set nls_comp = ANSI";
_command.ExecuteNonQuery();
_command.CommandText = "alter session set nls_sort = BINARY_CI";
_command.ExecuteNonQuery();
This does not seem to work.
Any pointers would really be appreciated!
Thanks
Chris
Oracle 10g, C# 3.5
I'm trying to set case insensitive searches base on what I have found on the web and tested in toad:
_command = new OracleCommand("", _connection);
_command.CommandText = "alter session set nls_comp = ANSI";
_command.ExecuteNonQuery();
_command.CommandText = "alter session set nls_sort = BINARY_CI";
_command.ExecuteNonQuery();
This does not seem to work.
Any pointers would really be appreciated!
Thanks
Chris