Need to provide a way to make LIKE queries case-insensitive

[destan]

https://stackoverflow.com/a/4635835/878361

also take into considiration that this process is locale sensitive and provide a way to override current locale https://stackoverflow.com/a/46306200/878361