Case sensitivity: lower/upper case for suggestions

[automated]

While filling out transacrions, the search for existing accounts (like companies as the counterpart) is case-sensitive.
It is very uncomfortable because sometimes the official spelling divers from the assumed spelling in terms of upper/lower case.

According to the maintainer of firefly-iii this is a db issue.

Is there any way to change the db config to be case-insenstivie for (auto-complete) suggestions?

More details here in issue #8187 in the project

[girish]

@automated I am confused how this is related to the database. The app needs to make case insensitive queries. I will follow up on the github issue tracker.

[girish]

@automated https://github.com/orgs/firefly-iii/discussions/8199

[automated]

Highly appreciated