Issue #2376239 by david_garcia, dobe: "format" field in table "date_format_locale" should be case sensitive

2 files changed, 17 insertions, 0 deletions

diff --git a/CHANGELOG.txt b/CHANGELOG.txt
index b988a1e2a..d3cf02b89 100644
--- a/CHANGELOG.txt
+++ b/CHANGELOG.txt
@@ -1,6 +1,8 @@
 
 Drupal 7.40, xxxx-xx-xx (development version)
 -----------------------
+- Made the format column in the {date_format_locale} database table
+  case-sensitive, to match the equivalent column in the {date_formats} table.
 - Fixed a bug in the Statistics module that caused JavaScript files attached to
   a node while it is being viewed to be omitted from the page.
 - Added an optional 'project:' prefix that can be added to dependencies in a
diff --git a/modules/system/system.install b/modules/system/system.install
index dde846969..323b7b356 100644
--- a/modules/system/system.install
+++ b/modules/system/system.install
@@ -800,6 +800,7 @@ function system_schema() {
         'type' => 'varchar',
         'length' => 100,
         'not null' => TRUE,
+        'binary' => TRUE,
       ),
       'type' => array(
         'description' => 'The date format type, e.g. medium.',
@@ -3178,6 +3179,20 @@ function system_update_7079() {
 }
 
 /**
+ * Convert the 'format' column in {date_format_locale} to case sensitive varchar.
+ */
+function system_update_7080() {
+  $spec = array(
+    'description' => 'The date format string.',
+    'type' => 'varchar',
+    'length' => 100,
+    'not null' => TRUE,
+    'binary' => TRUE,
+  );
+  db_change_field('date_format_locale', 'format', 'format', $spec);
+}
+
+/**
  * @} End of "defgroup updates-7.x-extra".
  * The next series of updates should start at 8000.
  */