search case-insensitive for authorities

jef · jef · commit 498cb41c54bc · 2010-03-23T15:29:56.000Z
git-svn-id: http://svn.osgeo.org/qgis/trunk@13145 c8812cc2-4d05-0410-92ff-de0c093fc19c
diff --git a/src/gui/qgsprojectionselector.cpp b/src/gui/qgsprojectionselector.cpp
@@ -206,7 +206,7 @@ void QgsProjectionSelector::showEvent( QShowEvent * theEvent )
     pbnPopular4->show();
   }
 
-  // Pass up the inheritance heirarchy
+  // Pass up the inheritance hierarchy
   QWidget::showEvent( theEvent );
 }
 
@@ -256,7 +256,7 @@ QString QgsProjectionSelector::ogcWmsCrsFilterAsSqlExpression( QSet<QString> * c
     QString prefix = " AND (";
     foreach( QString auth_name, authParts.keys() )
     {
-      sqlExpression += QString( "%1(auth_name='%2' AND auth_id IN ('%3'))" )
+      sqlExpression += QString( "%1(lower(auth_name)=lower('%2') AND auth_id IN ('%3'))" )
                         .arg( prefix )
                         .arg( auth_name )
                         .arg( authParts[auth_name].join( "','" ) );

Original file line number	Diff line number	Diff line change
`@@ -206,7 +206,7 @@ void QgsProjectionSelector::showEvent( QShowEvent * theEvent )`
`206`	`206`	`pbnPopular4->show();`
`207`	`207`	`}`
`208`	`208`
`209`		`- // Pass up the inheritance heirarchy`
	`209`	`+ // Pass up the inheritance hierarchy`
`210`	`210`	`QWidget::showEvent( theEvent );`
`211`	`211`	`}`
`212`	`212`
`@@ -256,7 +256,7 @@ QString QgsProjectionSelector::ogcWmsCrsFilterAsSqlExpression( QSet<QString> * c`
`256`	`256`	`QString prefix = " AND (";`
`257`	`257`	`foreach( QString auth_name, authParts.keys() )`
`258`	`258`	`{`
`259`		`- sqlExpression += QString( "%1(auth_name='%2' AND auth_id IN ('%3'))" )`
	`259`	`+ sqlExpression += QString( "%1(lower(auth_name)=lower('%2') AND auth_id IN ('%3'))" )`
`260`	`260`	`.arg( prefix )`
`261`	`261`	`.arg( auth_name )`
`262`	`262`	`.arg( authParts[auth_name].join( "','" ) );`