views:

204

answers:

0

How can I make some ful-text searching in non-english texts with sqlite? I use php5.3, with pdo_sqlite.

CREATE VIRTUAL TABLE example USING FTS3(title TEXT, TOKENIZE icu hu_HU)

This one is dont throw an Exception, but just a 0 byte length .sqlite file has been created. I dont see any virtual table. Below this link, i read that pdo_sqlite with ICU supported in php5.3 by default. I use XAMPP-1.7.2 on ubuntu 9.04. What is wrong? I am getting frustrated now, I am trying everything without success.

I found this, but It is wont help

Examle test code:

$dbh = new PDO($dsn);
try {
    // 1. query: This one is WORKING
    //$sql = "CREATE VIRTUAL TABLE example USING FTS3 (title TEXT, TOKENIZE SIMPLE)";
    // 2. query: This one is NOT WORKING, (resulted 0 byte length file),
    // without any error message or exception
    $sql = "CREATE VIRTUAL TABLE example USING FTS3(title TEXT, TOKENIZE icu hu_HU)";
    $affected = $dbh->exec($sql);
    echo $affected;
} catch(Exception $e) {
    echo '<pre>';print_r($e);echo '</pre>';
    throw $e;
}

$dbh = null;

Please help Me! And forget me for dehumiliating english language :)