Results 1 to 1 of 1
-
26th Oct 2011, 03:33 AM #1OPMemberWebsite's:
mafiaWarez.com phaze.co katzbb.com massddl.com buspic.comHow to Change Default Table Charset Collation
i need share some tutor about how to Mass convert mymsql table charset collation
example : Convert / change charset UTF-8 Collate to charset Latin 1 or ISO-8951-1 this it's will be change Mass
1. Open notepad and paste this script save with name wtf you need
ex: charset.php
PHP Code:<?php
// Database info
$dbhost = 'localhost';
$dbuser = 'your DB User here';
$dbpass = 'Your DB PAss here'
$dbname = 'Your DB Name Here';
//---------------
header('Content-type: text/plain');
$dbconn = mysql_connect($dbhost, $dbuser, $dbpass) or die( mysql_error() );
$db = mysql_select_db($dbname) or die( mysql_error() );
$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";
mysql_query($sql) or die( mysql_error() );
print "$table changed to iso-8859-1.\n";
}
mysql_close($dbconn);
?>
thanks-sky- Reviewed by -sky- on . How to Change Default Table Charset Collation i need share some tutor about how to Mass convert mymsql table charset collation example : Convert / change charset UTF-8 Collate to charset Latin 1 or ISO-8951-1 this it's will be change Mass 1. Open notepad and paste this script save with name wtf you need ex: charset.php <?php // Database info Rating: 5
Sponsored Links
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Similar Threads
-
Which is the best charset for dle
By amerriaz in forum DLEReplies: 4Last Post: 23rd Jan 2012, 06:09 AM -
How to Change Default Font Size of Posts/threads?
By Dardann in forum Technical Help Desk SupportReplies: 0Last Post: 6th Jan 2012, 08:34 PM -
Change Charset
By cca1690 in forum DLEReplies: 1Last Post: 13th Dec 2011, 06:40 PM -
Change Charset in DATALIFE
By cca1690 in forum Community CooperativeReplies: 4Last Post: 24th Nov 2011, 11:38 PM -
Default domain change
By v1r in forum Hosting DiscussionReplies: 3Last Post: 9th May 2008, 12:36 PM
themaRegister - register to forums...
Version 3.39 released. Open older version (or...