Problem importing database, portuguese chars
Hi, I’m trying to import a very small database (4mb) that was created with mysql4, but I have been having some problems with the character set, I'm new to mysql (I used to work with Oracle).
The previous database was created in mysql 4.0.x and was latin1 char set. When I install mysql 5.0 and do a restore, allot special characters, Portuguese characters 'ó' 'ã' 'ç' .... get garbled, and instead appears ‘?’ for example. When I create the new database I create it using latin1 with collation being latin1_swedish_ci am I using the wrong collation? One thing that puzzles me is that character_set_system is UTF8 when I explicitly said for the database to be in latin1, or is this independent since that database is in fact in latin1?
The system character set should be independent of database character set, right?
I’m trying to import trough a command line on windows XP:
create database xptodb default character set latin1 default collate latin1_swedish_ci
mysql –uroot –padmin xptodb < old.xpto.dump.file.sql
Is the problem the restore being done trough a command line? If so I should use something else? Has anyone got any suggestions? I used mysql front once but it was way to slow importing the data, even though I had the “set foreign_key_checks = 0;” on the beginning of the dump file.
Orlando
Subject
Views
Written By
Posted
Problem importing database, portuguese chars
7758
February 10, 2006 12:11PM
3451
February 13, 2006 04:58AM
5506
February 23, 2006 10:05AM
4248
May 25, 2007 08:03AM
3384
July 08, 2007 05:24PM
3474
June 05, 2006 04:55AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.