FOF30\Database\Installer::realGetColumnCollation PHP Method

    private function realGetColumnCollation($tableName, $columnName)
    {
        $collation = $this->getTableCollation($tableName);
        $query = 'SHOW FULL COLUMNS FROM ' . $this->db->qn($tableName) . ' LIKE ' . $this->db->q($columnName);
        try {
            $row = $this->db->setQuery($query)->loadAssoc();
        } catch (\Exception $e) {
            return $collation;
        }
        if (empty($row)) {
            return $collation;
        }
        if (!isset($row['Collation'])) {
            return $collation;
        }
        if (empty($row['Collation'])) {
            return $collation;
        }
        return $row['Collation'];
    }