how to export mysql data from latin to utf8
<?php echo "start..."; $outputfile= "OUTPUT.sql"; $DB_HOST="localhost"; $DB_USER="enaaa"; $DB_PASS="adfsda"; $DB_DBNAME='safds'; $DB_TABLE[]="g2_AccessMap"; $DB_TABLE[]="g2_AccessSubscriberMap"; $DB_TABLE[]="g2_AlbumItem"; $DB_TABLE[]="g2_AnimationItem"; $DB_TABLE[]="g2_CacheMap"; $DB_TABLE[]="g2_ChildEntity"; $DB_TABLE[]="g2_Comment"; $DB_TABLE[]="g2_DataItem"; $DB_TABLE[]="g2_Derivative"; $DB_TABLE[]="g2_DerivativeImage"; $DB_TABLE[]="g2_DerivativePrefsMap"; $DB_TABLE[]="g2_DescendentCountsMap"; $DB_TABLE[]="g2_Entity"; $DB_TABLE[]="g2_ExifPropertiesMap"; $DB_TABLE[]="g2_ExternalIdMap"; $DB_TABLE[]="g2_FactoryMap"; $DB_TABLE[]="g2_FailedLoginsMap"; $DB_TABLE[]="g2_FileSystemEntity"; $DB_TABLE[]="g2_Group"; $DB_TABLE[]="g2_ImageBlockCacheMap"; $DB_TABLE[]="g2_ImageBlockDisabledMap"; $DB_TABLE[]="g2_Item"; $DB_TABLE[]="g2_ItemAttributesMap"; $DB_TABLE[]="g2_Lock"; $DB_TABLE[]="g2_MaintenanceMap"; $DB_TABLE[]="g2_MimeTypeMap"; $DB_TABLE[]="g2_MovieItem"; $DB_TABLE[]="g2_PermissionSetMap"; $DB_TABLE[]="g2_PhotoItem"; $DB_TABLE[]="g2_PluginMap"; $DB_TABLE[]="g2_PluginPackageMap"; $DB_TABLE[]="g2_PluginParameterMap"; $DB_TABLE[]="g2_RatingCacheMap"; $DB_TABLE[]="g2_RatingMap"; $DB_TABLE[]="g2_RecoverPasswordMap"; $DB_TABLE[]="g2_Schema"; $DB_TABLE[]="g2_SequenceId"; $DB_TABLE[]="g2_SequenceLock"; $DB_TABLE[]="g2_SessionMap"; $DB_TABLE[]="g2_TkOperatnMap"; $DB_TABLE[]="g2_TkOperatnMimeTypeMap"; $DB_TABLE[]="g2_TkOperatnParameterMap"; $DB_TABLE[]="g2_TkPropertyMap"; $DB_TABLE[]="g2_TkPropertyMimeTypeMap"; $DB_TABLE[]="g2_UnknownItem"; $DB_TABLE[]="g2_User"; $DB_TABLE[]="g2_UserGroupMap"; $fp=fopen($outputfile, "w+"); if(!$fp){ echo "Can not open file for writing.\n"; exit; } $dbcon=mysql_connect($DB_HOST, $DB_USER, $DB_PASS); mysql_query("SET NAMES utf8", $dbcon); mysql_select_db($DB_DBNAME, $dbcon); foreach($DB_TABLE as $tableId=>$tableName){ $sqlstr="SELECT * FROM $tableName "; //echo $sqlstr; $rs=mysql_query($sqlstr, $dbcon); //$NAMESTR="SET NAMES utf8;\r\n\r\n"; //fwrite($fp, $NAMESTR, strlen($NAMESTR)); //echo "rs=" . $rs; while($rsrow=mysql_fetch_row($rs)){ $i_sqlstr="INSERT INTO $tableName VALUES("; foreach($rsrow as $rid=>$rval){ //echo $rval; $rsrow[$rid]= $rval;//iconv("BIG5", "UTF-8", $rval); if(strval($rid)=="0") $i_sqlstr.="'".addslashes($rsrow[$rid])."'"; else $i_sqlstr.=", '".addslashes($rsrow[$rid])."'"; } $i_sqlstr.=");\r\n\r\n"; echo $i_sqlstr; fwrite($fp, $i_sqlstr, strlen($i_sqlstr)); } mysql_free_result($rs); } mysql_close($dbcon); fclose($fp); exit; ?>