Search case sensitivity

[Iker]

Hi,

I have noticed that search is case sensitive. I haven't investigated deeply but I guess it could be customized, but are there plans to make search not case sensitive or add an option for the Admin UI to let the admins decide whether they want case sensitive search?

Thank you

[heidi]

Hi,

Case insensitivity is dependent on the database set up - independent of KonaKart.   You can set up your database to act the way you want in this regard.

Hence, there are no plans to add anything to KonaKart for this.

Regards,
Heidi

[Iker]

Hi,

Thanks for the quick reply. Unfortunately not all versions of the DBs support this type of setup (for example Oracle 9i doesn't, only from 10g and up) and not in all cases we can influence DB setup, as it is planned to work on an already existing DB instance. But I think I can live with it...

Thank you

[ming]

For Oracle, I saw this on an Oracle Forum about Oracle 9i: (I haven't tested this)

Code Select Expand


Connected to:
Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production

SQL> create table brisime (col varchar2(20));
Table created.

SQL> insert into brisime values ('Little Foot');
1 row created.

SQL> insert into brisime values ('LITTLE foot');
1 row created.

SQL> insert into brisime values ('little FOOT');
1 row created.

SQL> select * from brisime;
COL
--------------------
Little Foot
LITTLE foot
little FOOT

SQL> alter session set nls_comp = ANSI;
Session altered.

SQL> alter session set nls_sort = GENERIC_BASELETTER;

Session altered.

SQL> select * from brisime where col = 'little foot';

COL
--------------------
Little Foot
LITTLE foot
little FOOT

SQL>



I know some users on Oracle (10g +) have set code like this in login.sql scripts to set case-insensitve searching for the user:

Code Select Expand


begin
if user = 'KKUser' then
  execute immediate 'alter session set NLS_COMP=LINGUISTIC';
  execute immediate 'alter session set NLS_SORT=BINARY_CI';
end if;
end;



Which database are you unable to set case insensitive searching on ?
Regards,
Ming

[wafeneto]

you have any idea of how can i perform a search "case insensitive" using postgres sql? (looking in pg manual they told to use ilike command instead like, but how can i do this using konakart?)