N
nix1016
Guest
Thanks Aiden for your suggestion. I tried your process but unfortunately still got the same error. However, I have managed to narrow it down to a particular record that's causing this. Unfortunately I can't see from the ASCII dump what the exact issue with it is, i.e. I can't see any special characters nor unterminated double-quotes. Anyhow, this is bound to happen in other databases and if there is no way we can import the data in regardless of corrupt data/encoding, then we may as well do the binary dump and then convert UTF-8. I just tested this and it works fine with all of the data converted properly. Thanks for all your help!
Continue reading...
Continue reading...