Re: Database migration failing.
Posted by: Rick James
Date: June 06, 2011 10:06PM

There could be differences in the server's default charaset, the database's default charset, etc. I would expect the mysqldump to have all the charset values quite explicit; are they?

I say charset (character set) not collation, because that is the dominant issue. The latin1 charset has certain possible collations; they all begin with 'latin1'. The utf8 characterset has several utf8_... collations.

It may be as simple as setting an option on mysql as you reload the dump.

See this for more discussion (but not necessarily an explicit answer to your problem):
http://mysql.rjweb.org/doc.php/charcoll

Options: ReplyQuote


Subject
Views
Written By
Posted
4661
June 02, 2011 04:28AM
Re: Database migration failing.
1603
June 06, 2011 10:06PM
1718
June 07, 2011 02:49PM
1724
June 07, 2011 08:27PM
2536
June 08, 2011 10:44AM
1675
June 08, 2011 09:00PM
1585
June 09, 2011 09:59AM


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.