News for hackers. Stuff that matters.
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.
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...