Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- // Don't forget to enter your db infos.
- define('THIS_SCRIPT', 'convert');
- require './global.php';
- //---------------
- header('Content-type: text/plain');
- $dbconn = mysql_connect('localhost', 'vb385_user', 'PDJPGHts') or die( mysql_error() );
- mysql_select_db("pes5_vb385");
- $sql = "ALTER DATABASE `pes5_vb385` DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci";
- $result = mysql_query($sql) or die( mysql_error() );
- print "Database changed to latin\n";
- $sql = 'SHOW TABLES';
- $result = mysql_query($sql) or die( mysql_error() );
- while ( $row = mysql_fetch_row($result) )
- {
- $table = mysql_real_escape_string($row[0]);
- $sql = "ALTER TABLE $table DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci, CONVERT TO CHARACTER SET latin1 COLLATE latin1_general_ci";
- mysql_query($sql) or die( mysql_error() );
- print "$table changed to latin.\n";
- }
- mysql_close($dbconn);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement