I finished up with multiple fields for trainers and jocks in my database; title, first, second and surname plus initials where only available.
Even if you get your info from the same source all the time the names still can come in different format.
These days I can recall a good jock trainer from memory, not so easy if you use a bot.
We standardized railway tracks, mostly anyway, so it will only be another 100 years before we sort this out.