SQLite Forum

A thought on LIKE/GLOB optimization
Login
"This is true for all characters except..." is incorrect. `'a'` sorts after `'Z'` in `BINARY`, but between `'A'` and `'B'` in `NOCASE`.