fix_collate.php File Reference

Variables
	$charset = 'latin1'
	$collate = 'latin1_german1_ci'
	$sql = "SELECT CONCAT('ALTER TABLE `".$DB_STUDIP_DATABASE."`.`', TABLE_NAME, '` CONVERT TO CHARACTER SET ".$charset." COLLATE ".$collate.";') as query FROM `information_schema`.TABLES WHERE TABLE_SCHEMA='".$DB_STUDIP_DATABASE."' AND TABLE_COLLATION!='".$collate."'"
	$db = DBManager::get()
	$result = $db->query($sql)

Variable Documentation

$charset

$charset = 'latin1'

Author

Witali Mik mik@d.nosp@m.ata-.nosp@m.quest.nosp@m..de Script um Collation Konflikte automatisiert zu lösen

$collate

$collate = 'latin1_german1_ci'

$db

$db = DBManager::get()

$result

$result = $db->query($sql)

$sql

$sql = "SELECT CONCAT('ALTER TABLE `".$DB_STUDIP_DATABASE."`.`', TABLE_NAME, '` CONVERT TO CHARACTER SET ".$charset." COLLATE ".$collate.";') as query FROM `information_schema`.TABLES WHERE TABLE_SCHEMA='".$DB_STUDIP_DATABASE."' AND TABLE_COLLATION!='".$collate."'"