Index: webapp/WEB-INF/src/org/olat/basesecurity/PersistingManager.java
===================================================================
RCS file: /usr/local/cvs/olat3/webapp/WEB-INF/src/org/olat/basesecurity/PersistingManager.java,v
retrieving revision 1.55
diff -u -r1.55 PersistingManager.java
--- webapp/WEB-INF/src/org/olat/basesecurity/PersistingManager.java	7 Feb 2006 18:10:19 -0000	1.55
+++ webapp/WEB-INF/src/org/olat/basesecurity/PersistingManager.java	13 Jun 2006 12:04:46 -0000
@@ -729,37 +729,37 @@
 			if (login != null) {
 				login = makeFuzzyQueryString(login);
 				needsAnd = true;
-				sb.append(" ident.name like :login ");
+				sb.append(" lower(ident.name) like :login ");
 			}
 			if (first != null) {
 				first = makeFuzzyQueryString(first);
 				if (needsAnd) 	sb.append(" and ");
 				needsAnd = true;
-				sb.append(" ident.user.firstName like :first ");
+				sb.append(" lower(ident.user.firstName) like :first ");
 			}
 			if (last != null) {
 				last = makeFuzzyQueryString(last);
 				if (needsAnd) 	sb.append(" and ");
 				needsAnd = true;
-				sb.append(" ident.user.lastName like :last ");
+				sb.append(" lower(ident.user.lastName) like :last ");
 			}
 			if (email != null) {
 				email = makeFuzzyQueryString(email);
 				if (needsAnd) 	sb.append(" and ");
 				needsAnd = true;
-				sb.append(" (ident.user.email like :email or ident.user.institutionalEmail like :email)");
+				sb.append(" (lower(ident.user.email) like :email or lower(ident.user.institutionalEmail) like :email)");
 			}
 			if (inst != null) {
 				inst = makeFuzzyQueryString(inst);
 				if (needsAnd) 	sb.append(" and ");
 				needsAnd = true;
-				sb.append(" ident.user.institutionalName like :inst ");
+				sb.append(" lower(ident.user.institutionalName) like :inst ");
 			}
 			if (instId != null) {
 				instId = makeFuzzyQueryString(instId);
 				if (needsAnd) 	sb.append(" and ");
 				needsAnd = true;
-				sb.append(" ident.user.institutionalUserIdentifier like :instId ");
+				sb.append(" lower(ident.user.institutionalUserIdentifier) like :instId ");
 			}
 	
 			// append query for named security groups
@@ -831,17 +831,17 @@
 		
 		// add user attributes
 		if (login != null) 
-			dbq.setString("login", login);
+			dbq.setString("login", login.toLowerCase());
 		if (first != null) 
-			dbq.setString("first", first);
+			dbq.setString("first", first.toLowerCase());
 		if (last != null) 
-			dbq.setString("last", last);
+			dbq.setString("last", last.toLowerCase());
 		if (email != null) 
-			dbq.setString("email", email);
+			dbq.setString("email", email.toLowerCase());
 		if (inst != null) 
-			dbq.setString("inst", inst);
+			dbq.setString("inst", inst.toLowerCase());
 		if (instId != null) 
-			dbq.setString("instId", instId);
+			dbq.setString("instId", instId.toLowerCase());
 
 		// add named security group names
 		if (hasGroups) {
Index: webapp/WEB-INF/src/org/olat/repository/RepositoryManager.java
===================================================================
RCS file: /usr/local/cvs/olat3/webapp/WEB-INF/src/org/olat/repository/RepositoryManager.java,v
retrieving revision 1.58
diff -u -r1.58 RepositoryManager.java
--- webapp/WEB-INF/src/org/olat/repository/RepositoryManager.java	23 Feb 2006 17:32:15 -0000	1.58
+++ webapp/WEB-INF/src/org/olat/repository/RepositoryManager.java	13 Jun 2006 12:04:46 -0000
@@ -379,7 +379,7 @@
 			query.append("sgmsi.securityGroup = v.ownerGroup and "+
 			"sgmsi.identity = identity and "+
 			"identity.user = user and "+
-			"(user.firstName like :author or user.lastName like :author or identity.name like :author)");
+			"(lower(user.firstName) like :author or lower(user.lastName) like :author or lower(identity.name) like :author)");
 			previousWhere = true;
 		}
 
@@ -387,7 +387,7 @@
 			displayName = displayName.replace('*','%');
 			displayName = '%' + displayName + '%';
 			if (previousWhere) query.append(" and ");
-			query.append("v.displayname like :displayname");
+			query.append("lower(v.displayname) like :displayname");
 			previousWhere = true;
 		}
 
@@ -395,7 +395,7 @@
 			desc = desc.replace('*','%');
 			desc = '%' + desc + '%';
 			if (previousWhere) query.append(" and ");
-			query.append("v.description like :desc");
+			query.append("lower(v.description) like :desc");
 			previousWhere = true;
 		}
 
@@ -416,13 +416,13 @@
 		
 		DBQuery dbQuery = DB.getInstance().createQuery(query.toString());
 		if (var_author) {
-			dbQuery.setString("author", author);
+			dbQuery.setString("author", author.toLowerCase());
 		}
 		if (var_displayname) {
-			dbQuery.setString("displayname", displayName);
+			dbQuery.setString("displayname", displayName.toLowerCase());
 		}
 		if (var_desc) {
-			dbQuery.setString("desc", desc);
+			dbQuery.setString("desc", desc.toLowerCase());
 		}
 		if (var_resourcetypes) {
 			dbQuery.setParameterList("resourcetypes", resourceTypes, Hibernate.STRING);
