Cause of Death Fact

In my experience, the Description field is limited to 100 characters when exported. I strive to keep it short. For a true note of any length, the Note field needs to be used.

1 Like


That’s 1190 ASCII or Unicode characters, but some multibyte Unicode characters will reduce that number. The Description block itself isn’t “designed” to visually present the full contents at once, but rather “linearly” and likely incompatible with some Unicode characters either font-wise or as control characters/etc..

Note: a full Description block (100s of thousands of characters in the database) slows down Edit Window navigation.

1710 characters in a Narrative Report:

is the approx or a hard cap of 100? I never tested but I knew it was suggested to stay under around 100 chars.

@kevync1985 from other posts on here, it looks like the numbers varies between 100 and 200 BUT it is suggested you stick to 100 just in case…
I used a gedcom to export data to another program and everything I had in the description field and notes transferred

In the 1861 UK Census, Mel Acorn was enumerated 7 April 1861 at 100 Ashberry St in London England

1861 CENSUS
100 Ashbury St
London, England
Mel Acorn 51 Birmingham carpenter
Sissy wife 50 Birmingham
Tom son 30 London printer
Sarah dau 26 London sales lady
Sally Lee dau 29 London
Bob Lee son-in-law 30 London printer
John Lee grandson 6 London
Anna Simon mother 71 Birmingham
Simon Acorn father 71 Birmingham retired
Terry Doopler mother-in-law 75 Birmingham widowed own money

BUT when I tree shared the same info–Ancestry cut it off abt Bob Lee and the original census info was under the fact note–so definitely consider 100 as the best guide…

Yes Ancestry does things differently at times. Also that involved APIs so might related to that.
Good to know …

Also
”In the 1861 UK Census, Mel Acorn was enumerated …. Bob Lee"

is about 300 characters

Maybe it’s changed. It definitely used to be 100 characters.

1 Like

Probably so… likely per user feedback :wink:

1 Like

FWIW on my db

SELECT
AVG(LENGTH(EF.Details)) AS Avg_Length,
MIN(LENGTH(EF.Details)) AS Min_Length,
MAX(LENGTH(EF.Details)) AS Max_Length,
COUNT(*) AS Total_Records
FROM EventTable EF
JOIN FactTypeTable FT ON EF.EventType = FT.FactTypeID
WHERE FT.Name = ‘Death’
AND EF.Details IS NOT NULL
AND EF.Details != ‘’;