This is the right answer. I had the job of planning a schema update to fix this shitty design.

Saying that, unicode and character formats are incredibly complex things that are not easily implemented. For example two strings in utf-8 can contain the same number of characters but be hugely different in size (up to 3-4x different!). It’s well worth reading through some articles to get a feel of the important points.

Many years ago, my mother used the electric lawn mower without unspooling all the wire. When it finally shorted, all the plastic wire insulation was in the process of turning into a melty plastic soup. A Lesson Was Learned.

The reason isn’t resistance - it’s that the coiled wire makes an electromagnet that stores energy in the magnetic field. The alternating current in the mains switches 50 or 60 times a second. In each cycle the magnetic field is created, destroyed then recreated in the opposite direction, then destroyed. This dumps a lot of energy (and therefore heat) into the coil.