<?php
$db = mysql_connect("localhost", "username", "pass");
if(!$db) echo "Cannot connect to the database - incorrect details";
mysql_select_db('myuser_mydbname'); $result=mysql_query('show tables');
while($tables = mysql_fetch_array($result)) {
foreach ($tables as $key => $value) {
mysql_query("ALTER TABLE $value COLLATE utf8_slovenian_ci");
}}
echo "The collation of your database has been successfully changed!";
?>
Posts Tagged ‘mysql’
How to change the collation for all tables in a MySQL database to UTF-8?
Monday, February 22nd, 2010HeidiSQL – SUPB
Friday, August 8th, 2008Trenutno se igram s HeidiSQL ali SUPB(Sistem za Upravlanje Podatkovne Baze).
Za začetek vredu zadevca bomo videli kaj bo čas pokazal.
![[Valid RSS]](wp-content/uploads/valid-rss.png "Validate my RSS feed")
