RealFeedApp beta

The default built-in lower() function works for ASCII characters only

The default lower() function only converts ASCII characters; full Unicode support requires the ICU extension to avoid doubling the library size.

Field
programming
What they did
SQLite developers explained that the lower() function only works with ASCII letters, while full Unicode support requires the separate ICU extension because implementing it would nearly double the library's size.
Why it matters
This is useful for developers to avoid errors when comparing strings with non-Latin characters and to understand why standard functions do not convert Cyrillic or other languages.
#sqlite#lower#unicode#icu#ascii

Read the original →