Skip to content

Instantly share code, notes, and snippets.

@ahmeti
Last active February 12, 2017 11:36
Show Gist options
  • Save ahmeti/955f3adfd3f241eedc77569bc1503b71 to your computer and use it in GitHub Desktop.
Save ahmeti/955f3adfd3f241eedc77569bc1503b71 to your computer and use it in GitHub Desktop.
Wordpress Disable utf8mb4 Charset (Use utf8_general_ci)
<?php
# wp-includes/wp-db.php
/**
* Determines the best charset and collation to use given a charset and collation.
*
* For example, when able, utf8mb4 should be used instead of utf8.
*
* @since 4.6.0
* @access public
*
* @param string $charset The character set to check.
* @param string $collate The collation to check.
* @return array The most appropriate character set and collation to use.
*/
public function determine_charset( $charset, $collate ) {
/*
if ( ( $this->use_mysqli && ! ( $this->dbh instanceof mysqli ) ) || empty( $this->dbh ) ) {
return compact( 'charset', 'collate' );
}
if ( 'utf8' === $charset && $this->has_cap( 'utf8mb4' ) ) {
$charset = 'utf8mb4';
}
if ( 'utf8mb4' === $charset && ! $this->has_cap( 'utf8mb4' ) ) {
$charset = 'utf8';
$collate = str_replace( 'utf8mb4_', 'utf8_', $collate );
}
if ( 'utf8mb4' === $charset ) {
// _general_ is outdated, so we can upgrade it to _unicode_, instead.
if ( ! $collate || 'utf8_general_ci' === $collate ) {
$collate = 'utf8mb4_unicode_ci';
} else {
$collate = str_replace( 'utf8_', 'utf8mb4_', $collate );
}
}
// _unicode_520_ is a better collation, we should use that when it's available.
if ( $this->has_cap( 'utf8mb4_520' ) && 'utf8mb4_unicode_ci' === $collate ) {
$collate = 'utf8mb4_unicode_520_ci';
}*/
$charset='utf8';
$collate = 'utf8_general_ci';
return compact( 'charset', 'collate' );
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment