Re:Why do database columns have a character length of 191?
by paulryanrogers on Monday May 17, 2021 @04:07PM
(#27187796)
I always wondered how the index prefixing impacts RTL language strings.
[ Parent
| on HN ]
Re:Why do database columns have a character length of 191?
by duskwuff on Monday May 17, 2021 @04:59PM
(#27188370)
It doesn't. LTR/RTL only applies at display time -- the first character of a string is still stored first, regardless of whether it's going to show up on the left or the right side of the screen.
Re:Why do database columns have a character length of 191?
by adolph on Monday May 17, 2021 @05:07PM
(#27188464)
As I understand it, the bytes are ordered the same (without regarding big vs little endian). The RTL (or LTR) has to do with the visual representation and can be set by a nonprinting character.
https://en.wikipedia.org/wiki/Bidirectional_text
https://en.wikipedia.org/wiki/Right-to-left_mark
https://betterexplained.com/articles/understanding-big-and-l...