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



