Bug #68263 [Opn]: pdo sqlite unknown tokenizer: unicode61
Edit report at https://bugs.php.net/bug.php?id=68263&edit=1
ID: 68263
User updated by: erictsau at gmail dot com
Reported by: erictsau at gmail dot com
Summary: pdo sqlite unknown tokenizer: unicode61
Status: Open
Type: Bug
Package: SQLite related
-Operating System: Windows 8.1
+Operating System: all
-PHP Version: 5.6.2
+PHP Version: all
Block user comment: N
Private report: N
New Comment:
change version to all
Previous Comments:
------------------------------------------------------------------------
[2014-10-19 08:08:24] erictsau at gmail dot com
Description:
------------
Php does not have full support for sqlite3 fts4.
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General
error: 1 unknown tokenizer: unicode61' in test.php:4
Stack trace:
#0 test.php(4): PDO->exec('create virtual ...')
#1 {main}
thrown in test.php on line 4
add this compile flag to fix: -DSQLITE_ENABLE_FTS4_UNICODE61
Test script:
---------------
<?php
$pdo = new PDO('sqlite::memory:');
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo->exec('create virtual table a using fts4(s,c,b,tokenize=unicode61)');
$pdo->exec('insert into a values(0,9)');
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=68263&edit=1
Thread (3 messages)