- Patch #333054 by c960657: page cache should be case sensitive.

2 files changed, 13 insertions, 8 deletions

diff --git a/modules/locale/locale.install b/modules/locale/locale.install
index d9ef10afb..32d7d18d0 100644
--- a/modules/locale/locale.install
+++ b/modules/locale/locale.install
@@ -5,10 +5,6 @@
  * Implementation of hook_install().
  */
 function locale_install() {
-  // locales_source.source and locales_target.target are not used as binary
-  // fields; non-MySQL database servers need to ensure the field type is text
-  // and that LIKE produces a case-sensitive comparison.
-
   // Create tables.
   drupal_install_schema('locale');
 
@@ -354,7 +350,6 @@ function locale_schema() {
       ),
       'source' => array(
         'type' => 'text',
-        'mysql_type' => 'blob',
         'not null' => TRUE,
         'description' => 'The original string in English.',
       ),
@@ -383,7 +378,6 @@ function locale_schema() {
       ),
       'translation' => array(
         'type' => 'text',
-        'mysql_type' => 'blob',
         'not null' => TRUE,
         'description' => 'Translation string value in this language.',
       ),
diff --git a/modules/locale/locale.test b/modules/locale/locale.test
index 9e793dffb..258eb5125 100644
--- a/modules/locale/locale.test
+++ b/modules/locale/locale.test
@@ -391,8 +391,9 @@ class LocaleTranslationFunctionalTest extends DrupalWebTestCase {
     // This is the language indicator on the translation search screen for
     // untranslated strings. Copied straight from locale.inc.
     $language_indicator = "<em class=\"locale-untranslated\">$langcode</em> ";
-    // This will be the translation of $name.
-    $translation = $this->randomName(16);
+    // This will be the translation of $name. Make sure it contains at least
+    // one lower-case character in order to check case-sensitive search.
+    $translation = $this->randomName(16) . 'x';
 
     // Add custom language.
     $this->drupalLogin($admin_user);
@@ -469,6 +470,16 @@ class LocaleTranslationFunctionalTest extends DrupalWebTestCase {
     $this->drupalPost('admin/international/translate/translate', $search, t('Filter'));
     $this->assertNoText(t('No strings found for your search.'), t('Search found the translation.'));
 
+    // Ensure string search is case-sensitive.
+    $search = array(
+      'string' => drupal_strtoupper($translation),
+      'language' => 'all',
+      'translation' => 'translated',
+      'group' => 'all',
+    );
+    $this->drupalPost('admin/international/translate/translate', $search, t('Filter'));
+    $this->assertText(t('No strings found for your search.'), t("Search didn't find the translation."));
+
     // Ensure translated source string doesn't appear if searching on 'only
     // untranslated strings'.
     $search = array(