Charset trouble

[matheussousuke]

Hi guys, good morning.

I've just get this script for converting mysql tables from wordpress, and I want to use it in my server, but no with wordpress, with oscommerce, a friend of mine told me a few things I should do for make it working, but less than a rookie in PHP, began studying it now ¬¬", and sure I dont know how to use command line yet, she told me something about using command line along with FTP ascii table, I'm lost, couldn't do that, how do I install it? How do I configurate it?

Ps: the script is for converting ascii characters for utf-8 or latin1. If u have anything else that can help me instead of using it, please let me know, here u see how's oscommerce http://www.mghospedagem.com/catalog/
u can see on the left that there are strange characters (oscommerce chars configuration is correct, the trouble's with the server, I contacted em but they didn't nothing, that's why I'm trying to install this script)

Here goes the script "convert_to_utf 8_sql_generator _extended.txt"

<?php
/*
Template Name: Convert Database to UTF8 
 
Copyright 2007  Anders Stalheim Oefsdahl  (email : [e-mail])
Detail at http://www.mydigitallife.info/2007/07/22/how-to-convert-character-set-and-collation-of-wordpress-database/
 
Bug fix by My Digital Life on 22 June 2007.
 
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
 
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.
 
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 
*/
 
echo '<h1>Convert Database to UTF8</h1>';
 
echo '<p>This script generates SQL to convert existing tables to utf8, following the guide at <a href="http://codex.wordpress.org/Converting_Database_Character_Sets">http://codex.wordpress.org/Converting_Database_Character_Sets</a>, temporarily setting various fields to BLOB before setting them back to their respective types.</p>';
echo '<p>This is an extended script for databases which are already utf8 but the strings are in latin1. It converts existing tables and colums to latin1 before the BLOB conversion</p>';
echo '<p>Please note that you probably will get some errors running the scripts, regarding key length on some tables. These errors can be ignored (at least I did :).</p>';
 
require_once("wp-config.php");
global $wpdb;
 
/**
 * Fetch all tables
 */
$tables = array();
$sql_tables = "SHOW TABLES";
$res_tables = $wpdb->get_results( $sql_tables );
if( is_array( $res_tables ) ){
    foreach( $res_tables as $res_table ){
        if(strpos($res_table->Tables_in_DATABASENAME, $table_prefix) === 0)
        $tables[$res_table->Tables_in_DATABASENAME] = array();
    }
}
/**
 * Loop all tables fetching each table's fields and filter out fields of type CHAR, VARCHAR, TEXT, ENUM, and SET (and related variations)
 */
if( count( $tables )>0 ){
    foreach( $tables as $table=>$fields ){
//        if (strpos($table_prefix, $table) == 0)
//        {
            $sql_fields = "EXPLAIN ".$table;
            $res_fields = $wpdb->get_results( $sql_fields );
            if( is_array( $res_fields ) ){
                foreach( $res_fields as $field ){
                    switch( TRUE ){
                        case strpos( strtolower( $field->Type ), 'char' )===0:
                        case strpos( strtolower( $field->Type ), 'varchar' )===0:
                        case strpos( strtolower( $field->Type ), 'text' )===0:
                        case strpos( strtolower( $field->Type ), 'enum' )===0:
                        case strpos( strtolower( $field->Type ), 'set' )===0:
                        case strpos( strtolower( $field->Type ), 'tinytext' )===0:
                        case strpos( strtolower( $field->Type ), 'mediumtext' )===0:
                        case strpos( strtolower( $field->Type ), 'longtext' )===0:
                            $tables[$table][$field->Field] = $field->Type;
                            break;
 
                        default:
                            break;
                    }
                }
//            }
        }
    }
}
 
$tables_to_latin1    = '';
$tables_to_utf8        = '';
$columns_to_latin1    = '';
$columns_to_blob    = '';
$columns_to_utf8    = '';
 
foreach( $tables as $table=>$fields ){
    $tables_to_latin1 .= "\nALTER TABLE ".$table." DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;";
    $tables_to_utf8 .= "\nALTER TABLE ".$table." DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;";
    if( count( $fields )>0 ){
        foreach( $fields as $name=>$type ){
            $columns_to_latin1 .= "\nALTER TABLE ".$table." MODIFY ".$name." CHARACTER SET latin1 COLLATE latin1_swedish_ci;";
            $columns_to_blob .= "\nALTER TABLE ".$table." MODIFY ".$name." BLOB;";
            $columns_to_utf8 .= "\nALTER TABLE ".$table." MODIFY ".$name." ".$type.";";
        }
    }
}
 
//$complete_sql = $sql_to_blob."\nALTER DATABASE ".DB_NAME." charset=utf8;".$sql_to_utf8.$sql_to_original;
$complete_sql = $tables_to_latin1."\n".$columns_to_latin1."\n".$columns_to_blob."\n".$tables_to_utf8."\n".$columns_to_utf8;
 
echo nl2br( $complete_sql );
 
?>

[Markus]

This seems like overkill. You might just change the content-type header of the page to something like: ISO-8859-1.

<head>
 <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
</head>
<body>
...
 

[matheussousuke]

Sorry, but...
I already did it =/

[Markus]

Try 'utf-8'.

[matheussousuke]

It doesn't works, I tried both. That friend of mine told me that the trouble is with the server, that I should install a script that correct that. She did it in her server, made a script and it worked,
I asked if she could handle me the script but she sad she spent hours making it, now I found that one on the internet, shown her and she said that it will work if I install it corretly, she tryied to teach me how to install and configurate but dindt has too much time, she has been pretty busy.

[matheussousuke]

Anyone?

...

...

...