Bug #68263 [Opn]: pdo sqlite unknown tokenizer: unicode61

From: Date: Sun, 19 Oct 2014 08:50:19 +0000
Subject: Bug #68263 [Opn]: pdo sqlite unknown tokenizer: unicode61
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-188188@lists.php.net to get a copy of this message
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)

« previous php.bugs (#188188) next »