View source for JDatabaseMySQL/getCollation

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

<span class="editsection" style="font-size:76%;">
	<nowiki>[<! removed edit link to red link >]</nowiki>
</span>

<! removed transcluded page call, red link never existed >

===Syntax===
<source lang="php">getCollation()</source>


===Returns===
string Collation in use 

===Defined in===
libraries/joomla/database/database/mysql.php
===Importing===
<source lang="php">jimport( 'joomla.database.database.mysql' );</source>

===Source Body===
<source lang="php">
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)";
        }
}
</source>

<span class="editsection" style="font-size:76%;">
	<nowiki>[<! removed edit link to red link >]</nowiki>
</span>
<! removed transcluded page call, red link never existed >

===Examples===
<CodeExamplesForm />
<dpl>
 noresultsheader=\n
 category=getCollation
 category=JDatabaseMySQL
 category=CodeExample
 category=MethodExample
 include=*
 format= ,,,
</dpl>
[[Category:Archived pages API15]]