dimanche 31 mai 2015

Full Text Search SQL has different effect between ios8 and ios7

I have use the "*" symbols to do selecting on ios7 sqlite which the effect what i want, but ios8 sqlite does not supporting "*" and show "no result". Is the FMDB problem or the ios 8 does not support the "*" symbols?

SQL(with FMDB):

db.executeQuery("SELECT * FROM TABLE_1 WHERE col_1 MATCH ?",withArgumentsInArray:["*A*"])

Table:

    +==============================+
    |     Name: TABLE_1            |
    +------------------------------+
    |   col_1     |     Result     |
    +==============================+
    |     A       |      result 1  |
    +------------------------------+
    |     B       |      result 2  |
    +------------------------------+
    |     AAB     |      result 3  |
    +------------------------------+

Aucun commentaire:

Enregistrer un commentaire