API16:JDatabaseMySQLi/getCollation

This Namespace has been archived - Please Do Not Edit or Create Pages in this namespace. Pages contain information for a Joomla! version which is no longer supported. It exists only as a historical reference, will not be improved and its content may be incomplete.

Description

Assumes database collation in use by sampling one text field in one table

Syntax

getCollation()

Returns

string Collation in use

Defined in

libraries/joomla/database/database/mysqli.php

Importing

jimport( 'joomla.database.database.mysqli' );

Source Body

public function getCollation ()
{
        if ($this->hasUTF()) {
                $this->setQuery('SHOW FULL COLUMNS FROM #__content');
                $array = $this->loadAssocList();
                return $array['4']['Collation'];
        } else {
                return "N/A (mySQL < 4.1.2)";
        }
}

Examples

<CodeExamplesForm />