source/Application/Controller/Admin/DynamicExportBaseController.php
protected function _generateTableCharSet($sMysqlVersion)
    {
        $sTableCharset = "";

        //if MySQL >= 4.1.0 set charsets and collations
        if (version_compare($sMysqlVersion, '4.1.0', '>=') > 0) {
            $oDB = \OxidEsales\Eshop\Core\DatabaseProvider::getDb(\OxidEsales\Eshop\Core\DatabaseProvider::FETCH_MODE_ASSOC);
            $oRs = $oDB->select("SHOW FULL COLUMNS FROM `oxarticles` WHERE field like 'OXID'");
            if (isset($oRs->fields['Collation']) && ($sMysqlCollation = $oRs->fields['Collation'])) {
                $oRs = $oDB->select("SHOW COLLATION LIKE '{$sMysqlCollation}'");
                if (isset($oRs->fields['Charset']) && ($sMysqlCharacterSet = $oRs->fields['Charset'])) {
                    $sTableCharset = "DEFAULT CHARACTER SET {$sMysqlCharacterSet} COLLATE {$sMysqlCollation}";
                }
            }
        }

        return $sTableCharset;
    }
protected function _generateTableCharSet($sMysqlVersion)
    {
        $sTableCharset = "";

        //if MySQL >= 4.1.0 set charsets and collations
        if (version_compare($sMysqlVersion, '4.1.0', '>=') > 0) {
            $oDB = \OxidEsales\Eshop\Core\DatabaseProvider::getDb(\OxidEsales\Eshop\Core\DatabaseProvider::FETCH_MODE_ASSOC);
            $oRs = $oDB->select("SHOW FULL COLUMNS FROM `oxarticles` WHERE field like 'OXID'");
            if (isset($oRs->fields['Collation']) && ($sMysqlCollation = $oRs->fields['Collation'])) {
                $oRs = $oDB->select("SHOW COLLATION LIKE '{$sMysqlCollation}'");
                if (isset($oRs->fields['Charset']) && ($sMysqlCharacterSet = $oRs->fields['Charset'])) {
                    $sTableCharset = "DEFAULT CHARACTER SET {$sMysqlCharacterSet} COLLATE {$sMysqlCollation}";
                }
            }
        }

        return $sTableCharset;
    }
protected function _generateTableCharSet ( $ sMysqlVersion ) { $ sTableCharset = "" ; //if MySQL >= 4.1.0 set charsets and collations if ( version_compare ( $ sMysqlVersion , '4.1.0' , '>=' ) > 0 ) { $ oDB = \ OxidEsales \ Eshop \ Core \ DatabaseProvider :: getDb ( \ OxidEsales \ Eshop \ Core \ DatabaseProvider :: FETCH_MODE_ASSOC ) ; $ oRs = $ oDB -> select ( "SHOW FULL COLUMNS FROM `oxarticles` WHERE field like 'OXID'" ) ; if ( isset ( $ oRs -> fields [ 'Collation' ] ) && ( $ sMysqlCollation = $ oRs -> fields [ 'Collation' ] ) ) { $ oRs = $ oDB -> select ( "SHOW COLLATION LIKE '{$sMysqlCollation}'" ) ; if ( isset ( $ oRs -> fields [ 'Charset' ] ) && ( $ sMysqlCharacterSet = $ oRs -> fields [ 'Charset' ] ) ) { $ sTableCharset = "DEFAULT CHARACTER SET {$sMysqlCharacterSet} COLLATE {$sMysqlCollation}" ; } } } return $ sTableCharset ; }
generates table charset

@param string $sMysqlVersion MySql version

@return string
generates table charset