SQLite Volltext-Suche

[galex9]

Wieso nicht einfach:

Code:

select id from vorname_tabele where lower(vorname) = :vorname_aus_dem_code_in_klein

Dabei muss man beachten was in Dokumetation zu sqlite steht:

Zitat:

The lower(X) function returns a copy of string X with all ASCII characters converted to lower case. The default built-in lower() function works for ASCII characters only. To do case conversions on non-ASCII characters, load the ICU extension.