On 1/7/15, The Responsa Project gr.respo...@biu.ac.il wrote:
To Whom it amy concern
I am trying to use SQLITE and the like statement with wildcards and hebrew
when I put in an english string it works correctly, such as
Select * from dbname where colname like '%123%'
I will get all the
To Whom it amy concern
I am trying to use SQLITE and the like statement with wildcards and hebrew
when I put in an english string it works correctly, such as
Select * from dbname where colname like '%123%'
I will get all the entries from that column that contain 123 anywhere in the
column.
On 2015/01/07 12:13, The Responsa Project wrote:
To Whom it amy concern
I am trying to use SQLITE and the like statement with wildcards and hebrew
when I put in an english string it works correctly, such as
Select * from dbname where colname like '%123%'
I will get all the entries from
How about to use dynamic binding?
For example, is your SQL(SELECT * from dbname where colname like '%אב%'),
use '?' instead of 'אב'.
In my guess, 'אב' can have same ASCII code of wildcard(%).
Full SQL can be as like as follows.
SELECT * from dbname where colname like '%?%'
To do this, you need