search to the table to be case insensitive

Asked Mar 05 '23 at 15:28

Active Mar 06 '23 at 06:09

Viewed 236 times

golang
DB.Select("name, vin_id").Where("UPPER(name) LIKE UPPER(?)", "%"+name+"%").Find(&vins)

Why is this working??? Golang GORM

SQL
select * from Table_Name
where  UPPER(Column_Name) = UPPER('mY Any Value')

I want the search to the table to be case insensitive

edited Mar 05 '23 at 21:02

blackgreen

asked Mar 05 '23 at 15:28

Pavel

Which database are you using? – Mattia Righetti Mar 05 '23 at 15:38
@Mattia Righetti Sqlite3 – Pavel Mar 06 '23 at 04:59
`code` r.DB.Select("name, vin_id").Where("LOWER(name) LIKE ?", strings.ToLower("%"+name+"%")).Find(&vins) This also doesn't work((( – Pavel Mar 06 '23 at 05:14
The `like` statement is case-insensitive by default, [sqlite FAQ](https://sqlite.org/faq.html#q18) – Mattia Righetti Mar 06 '23 at 09:03
@Mattia Righetti I did it through COLLATE СOCASE but it only works with ASCII, but I need it to work with Cyrillic – Pavel Mar 06 '23 at 09:15
https://stackoverflow.com/questions/3176618/searching-a-sqlite-database-which-contains-cyrillic-data – Mattia Righetti Mar 06 '23 at 09:53

0 Answers0