Do the source and target databases have the same character set? This is one of the most often-overlooked issues for data transfers. If I have ensured that standards are in place, hopefully the two databases’ character sets match, or at least the target database’s character set is a superset of the source database’s character set. Otherwise, if I attempt to import data into my target database, and the target database’s character set is not a superset of the source database’s character set, there is a good probability that character data will be corrupted, unconvertible, or simply lost.
90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.