leikind / wice_grid

A Rails grid plugin to create grids with sorting, pagination, and (automatically generated) filters
MIT License
536 stars 215 forks source link

Filtering among cyrillic data is case sensitive #292

Closed marat-y closed 8 years ago

marat-y commented 8 years ago

Filtering among cyrillic data is case sensitive. Is there anyway I can get around this?

leikind commented 8 years ago

which DB are you using?

marat-y commented 8 years ago

sqlite

leikind commented 8 years ago

even in production? 😼

leikind commented 8 years ago

http://stackoverflow.com/questions/15480319/case-sensitive-and-insensitive-like-in-sqlite

leikind commented 8 years ago

you can also change the SQL operator used for matching strings in string filters: https://github.com/leikind/wice_grid/blob/rails3/lib/generators/wice_grid/templates/wice_grid_config.rb#L49

marat-y commented 8 years ago

But filtering english text is not case-sensitive, while filtering russian text (cyrillic letters) is case-sensitive.

leikind commented 8 years ago

I fail to understand what WiceGrid has to do with an Sqlite problem? WiceGrid uses ActiveRecord, you are using Sqlite, you should be looking for the answer to your question elsewhere.