Feature details

Hello.

I've found out that the search for non-Latin characters is case-sensitive. So when I search for сбер, it cannot find occurrences of Сбер, for example.

I found out why this is happening. By default, the LIKE operator in this query is case-sensitive for Unicode characters. To make it case-insensitive, you must compile and load the ICU extension. Here is the link to this extension: link

I've managed to compile and change the gd script to solve the issue. However, I'm unsure how to integrate my changes into the main branch.

So, at least, I wanted to share the steps that I took to achieve this:

Installed icu4c, ruby, gcc and pkg-config packages with brew:
```
$ brew install icu4c ruby gcc pkg-config
```
Downloaded and untared the source code of sqlite3 via this link: https://www.sqlite.org/src/tarball/sqlite.tar.gz?r=release
```
$ wget 'https://www.sqlite.org/src/tarball/sqlite.tar.gz?r=release' -O sqlite.tar.gz
$ tar xzvf sqlite.tar.gz
```

Compiled the extension:

$ cd ~/Downloads/sqlite/ext/icu
$ export PKG_CONFIG_PATH="$(brew --prefix icu4c)/lib/pkgconfig"
$ gcc -fPIC -dynamiclib icu.c `pkg-config --libs --cflags icu-uc icu-io` -o libicu.dylib -I../../src

Note if your command output complains like that:

$ pkg-config --libs --cflags icu-uc icu-io
Package icu-uc was not found in the pkg-config search path.
Perhaps you should add the directory containing `icu-uc.pc'
to the PKG_CONFIG_PATH environment variable
No package 'icu-uc' found
Package icu-io was not found in the pkg-config search path.
Perhaps you should add the directory containing `icu-io.pc'
to the PKG_CONFIG_PATH environment variable
No package 'icu-io' found

Then you need to set PKG_CONFIG_PATH environment variable before trying to compile the extension.

You need to install sqlite3 gem for Homebrew ruby:
```
$ $(brew --prefix ruby)/bin/gem install sqlite3
```
Patched the gd script so it would use Homebrew ruby (I have an Apple Silicon Mac, so my Homebrew is under the/opt folder) and would load the extension:
```
#!/opt/homebrew/opt/ruby/bin/ruby
# frozen_string_literal: true
```

require 'json' require 'sqlite3'

[...]

Filter paths

db = SQLite3::Database.new(Cache_file) db.enable_load_extension(true)

NB: Your path might be different

db.load_extension("/Users/ivan/Downloads/sqlite/ext/icu/libicu.dylib") Results = db.execute("SELECT fullpath FROM main WHERE #{Dir_only} #{Array.new(Query.length, 'basename LIKE ?').join(' AND ')} ORDER BY accesstime DESC LIMIT ?;", Query, Limit).flatten



That's it. After these changes, everything works like a charm!

<img width="764" alt="image" src="https://github.com/alfredapp/google-drive-workflow/assets/188117/7ec85004-6851-473c-8187-d61602471b6e">

Can we integrate my description of steps into the official manual? What do you think?

Regards,
vanushah

alfredapp / google-drive-workflow

Case-insensitive Search for non-ASCII Unicode Characters #63

Feature details

[...]

Filter paths

NB: Your path might be different