<?php
/*
+--------------------------------------------------------------------+
- | CiviCRM version 4.7 |
+ | CiviCRM version 5 |
+--------------------------------------------------------------------+
- | Copyright CiviCRM LLC (c) 2004-2017 |
+ | Copyright CiviCRM LLC (c) 2004-2018 |
+--------------------------------------------------------------------+
| This file is a part of CiviCRM. |
| |
* Just another collection of static utils functions.
*
* @package CRM
- * @copyright CiviCRM LLC (c) 2004-2017
+ * @copyright CiviCRM LLC (c) 2004-2018
*/
class CRM_Utils_SQL {
// CRM-21455 MariaDB 10.2 does not support ANY_VALUE
$version = CRM_Core_DAO::singleValueQuery('SELECT VERSION()');
- if (stripos('mariadb', $version) !== FALSE) {
+ if (stripos($version, 'mariadb') !== FALSE) {
return FALSE;
}
* @return bool
*/
public static function isGroupByModeInDefault() {
- if (!self::supportsFullGroupBy()) {
- return FALSE;
- }
$sqlModes = explode(',', CRM_Core_DAO::singleValueQuery('SELECT @@global.sql_mode'));
if (!in_array('ONLY_FULL_GROUP_BY', $sqlModes)) {
return FALSE;
return TRUE;
}
+ /**
+ * Is the Database set up to handle acceents.
+ * @warning This function was introduced in attempt to determine the reason why the test getInternationalStrings was failing on ubu1604 but passing on ubu1204-5
+ * This function should not be used as the basis of further work as the reasoning is not perfact and is giving false failures.
+ * @return bool
+ */
+ public static function supportStorageOfAccents() {
+ $charSetDB = CRM_Core_DAO::executeQuery("SHOW VARIABLES LIKE 'character_set_database'")->fetchAll();
+ $charSet = $charSetDB[0]['Value'];
+ if ($charSet == 'utf8') {
+ return TRUE;
+ }
+ return FALSE;
+ }
+
}