SQLite - Text function and operator
About
Sqlite snippet over Sqlite function
List
Concat
a || b
Lower / Upper
- For Ascii characters
lower(colA)
upper(colB)
- For unicode character, you must have the International ICU extension loaded
Does not work on Java
Camel Case
substr(textColumnName,1,1) || lower(substr(textColumnName,2))