Posts Tagged ‘mysql’

How to change the collation for all tables in a MySQL database to UTF-8?

Monday, February 22nd, 2010
<?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!";
?>

HeidiSQL – SUPB

Friday, August 8th, 2008

Trenutno se igram s HeidiSQL ali SUPB(Sistem za Upravlanje Podatkovne Baze).

Za začetek vredu zadevca bomo videli kaj bo čas pokazal.



Opera web browser - download si.blogs page counter Firefox 3 Blogres.si [Valid RSS]
Valid CSS! Valid XHTML 1.0 StrictBloger.si
Drugi svet - slovenski blogerski casopis www.mojavizitka.com - spletna vizitka
Spletno Mesto, gostovanje, domene, optimizacija, izdelava spletnih strani
Spletno Gostovanje
Add to Google
Technorati Profile