Problem importing database, portuguese chars
Posted by: Orlando Reis
Date: February 10, 2006 12:11PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Problem importing database, portuguese chars
7758
February 10, 2006 12:11PM


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.