diff options
| -rw-r--r-- | includes/database.mysql.inc | 3 | ||||
| -rw-r--r-- | includes/database.mysqli.inc | 2 |
2 files changed, 4 insertions, 1 deletions
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; diff --git a/includes/database.mysqli.inc b/includes/database.mysqli.inc index 47390eb8e..b1b4f3b7f 100644 --- a/includes/database.mysqli.inc +++ b/includes/database.mysqli.inc @@ -120,6 +120,8 @@ function _db_query($query, $debug = 0) { } if (!mysqli_errno($active_db)) { + // Require ANSI mode to improve SQL portability. + mysqli_query($active_db, "SET SESSION sql_mode='ANSI'"); return $result; } else { |