Author
Reply
  • #14109

    Sorry for the delayed response – busy weekend.

    SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘s_name’ at row 1

    ‘s_name’ is “Source name”. Limited to 255 characters.

    Any tips on how to find the culprit would be _much_ appreciated! It’s a large ged.

    The ged also has \x92,93,94 and 96 – fixed those with HxD. Was/is there a way to change encoding to allow extended character set?

    These are UTF-8 encoded strings. Thats normal, so shouldn’t be a problem.
    But check your GEDCOM file. Near the start shoulld be a line like

    1 CHAR UTF-8

    If it says anything other than UTF-8, and you have no other reason for a different character set, just change it and re-import.

    Nigel
    My personal kiwitrees site is www.our-families.info