Liz Steel wrote:
I have a problem that I'm hoping someone has already solved, or at least
can point me in the right direction.
I am using LIKE in a SELECT statement to search my database. Everything
is fine when using standard English characters, and the select is not
case sensitive, which is what I want
However, if I use Swedish/German characters, for example �� �� �� ��,
then the select is not case sensitive.
I realise that this is a known issue with the current version of SQLite,
but I am hoping that someone can point me in the right direction to
solve this, either in the SQL statement itself, or in my code. (I am
using Visual C++.)
You can use the sqlite_create_function() API to register a new
SQL function named "like". That function will be called to implement
the LIKE keyword. You can code your revised "like" function to do
whatever you want. I would suggest making a copy of the "like"
function that is built into SQLite and modifying it to suit your
needs.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
