it worries me that this is left to the application developer, I would expect the database tx would throw exception if I try to put in db breaking things in it
and that this isn’t documented with suitably scary disclaimers “you need to check this length yourself, or your database might break”
I agree. I’m in the midst of a painful project to backfill this into a large database