Update 11-11-2019 See my answer below.
When dumping a Drupal CiviCRM database to move and convert to a new WordPress install, I've found that the membership data appears to have been encrypted; these random character strings appear in WordPress in Memberships>Dashboard, i.e. bs00fgcb
for name, hgaibbsf@example.org
for email, etc. But the two letter state abbreviation isn't a random string.
The garbage data appears in the database dump when viewed with a text editor, before I import into the new database.
No other database data seems to be affected, and CiviCRM appears to run fine in WordPress, other than the data display above.
Does this appear to be encryption? There are no encryption modules in Drupal (no Drupal Encrypt) that I can see., nor CiviCRM extensions Where would I find the functions that do the encryption and decrypting? In Drupal [cms.root]/sites/default/files/civicrm/custom/
? Or could encryption be done at the MySQL level?
CiviCRM is the same version between Drupal and WordPress; same MySQL database and encoding (both sites are on the same server). Database collations are exactly the same between the two: latin1_swedish_ci. No other data is corrupted. I've tried importing multiple times.