[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-commits
Subject:    branches/extragear/graphics/digikam/1.0-databaseext/libs/database
From:       Holger Foerster <hamsi2k () freenet ! de>
Date:       2010-03-01 22:01:39
Message-ID: 1267480899.160806.11688.nullmailer () svn ! kde ! org
[Download RAW message or body]

SVN commit 1097692 by foerster:

Don't use COLLATE NOCASE for now. The whole statements will be defined db specific in dbconfig.xml.

 M  +2 -1      albumdb.cpp  


--- branches/extragear/graphics/digikam/1.0-databaseext/libs/database/albumdb.cpp #1097691:1097692
@@ -2563,6 +2563,7 @@
     if (albumRootPath.isNull())
         return QStringList();
 
+    //TODO lets define SQL actions within dbconfig.xml
     QString sqlString;
     switch(sortOrder)
     {
@@ -2570,7 +2571,7 @@
             sqlString = QString("SELECT Albums.relativePath, Images.name "
                                  "FROM Images INNER JOIN Albums ON Albums.id=Images.album "
                                  "WHERE Albums.id=? "
-                                 "ORDER BY Images.name COLLATE NOCASE;");
+                                 "ORDER BY Images.name;"); //  COLLATE NOCASE
             break;
         case ByItemPath:
             // Don't collate on the path - this is to maintain the same behavior
[prev in list] [next in list] [prev in thread] [next in thread]