“Transparent tape” (Sellotape, Scotchtape) is glossy-surfaced cellulose tape. It will effect emergency repairs to torn paperwork,
but over time it will yellow and become brittle, and the adhesive will give up. Its limitations are clear if you spend any time viewing documents from the first half of the 20th century, when it was the only repair option available.
“Invisible tape” is a thin polyester tape with a matte surface. On paper, it becomes almost invisible, because the matte surface reflects no highlights. It does not yellow with age, and joints I made with it more than fifty years ago are still holding up fine. It is more expensive than transparent tape, but if what you want is longevity, it is the best option.