Charset in the ImpConfig page

[creativepart]

I'm wondering what the best thing to put in the ImpConfig page for charset? Should I put uft8 or latin1_swedish_ci? It seems that most if not all of my database tables are set to the default latin1_swedish_ci. Can I leave it blank?

I also did a search here and saw a change to the db_mysql.php file. Should I make that change (removing a utf8 reference in that file) or should that be made only if I have problems.

Thanks -- collation is a confusing thing.
Paul

[Colin F]

You should be able to leave it blank.

[creativepart]

Thanks but what about that change that has been suggested 5 or 6 times recently on this forum -- changing db_mysql.php. Should that be something I do as a matter of course or only if I end up with problems?

Here is the change I'm asking about:

Try this. Edit impex/db_mysql.php and change this line:

$query_id = $query_type(utf8_encode($query_string), $this->link_id);

To this:

$query_id = $query_type($query_string, $this->link_id);

[Colin F]

Ignore that for now. If you have any issues than there's a setting that you can edit. There's no need to edit the file directly.