From ef736430e5c16b9370227ee9958ece36953062af Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Sun, 17 Feb 2008 19:39:11 +0000
Subject: - Patch #212918 by pwolanin: enable MySQL's ANSI-mode.  We can chose
 to disable this when we ship Drupal 7, but it is really helpful during the
 development cycle.

---
 includes/database.mysql.inc | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'includes/database.mysql.inc')

diff --git a/includes/database.mysql.inc b/includes/database.mysql.inc
index a71c2371a..e8f831d71 100644
--- a/includes/database.mysql.inc
+++ b/includes/database.mysql.inc
@@ -79,7 +79,8 @@ function db_connect($url) {
     // Show error screen otherwise
     _db_error_page(mysql_error());
   }
-
+  // Require ANSI mode to improve SQL portability.
+  mysql_query("SET SESSION sql_mode='ANSI'", $connection);
   // Force UTF-8.
   mysql_query('SET NAMES "utf8"', $connection);
   return $connection;
-- 
cgit v1.2.3