Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re^3: Using the unicode61 tokenizer in DBD::SQLite

by Anonymous Monk
on Jan 06, 2014 at 21:51 UTC ( #1069587=note: print w/ replies, xml ) Need Help??


in reply to Re^2: Using the unicode61 tokenizer in DBD::SQLite
in thread Using the unicode61 tokenizer in DBD::SQLite

Um, I'm on windows too .... if you don't recognize cpanp -z... perl Makefile... you probably want to read A Guide To Installing Modules ... among others


Comment on Re^3: Using the unicode61 tokenizer in DBD::SQLite
Re^4: Using the unicode61 tokenizer in DBD::SQLite
by elef (Friar) on Jan 07, 2014 at 10:00 UTC
    I seem to have missed that bit. Are you saying that the unicode61 tokenizer works out of the box in 1.41_03?

      I seem to have missed that bit. Are you saying that the unicode61 tokenizer works out of the box in 1.41_03?

      I don't know; If the stuff I copy/pasted means unicode61 is working, then I guess it is.

        I got 1.41_03 installed using the cpan shell with install ISHIGAKI/DBD-SQLite-1.41_03.tar.gz.
        Still no dice:
        use strict; use warnings; use DBI; my $dbh = DBI->connect( "dbi:SQLite:dbname=test.db", "", "", { # RaiseError => 1, # we'll hand +le the errors ourselves sqlite_unicode => 1, } ) or die "Can't connect to database: $DBI::err +str"; my $sqliteversion = $dbh->{sqlite_version}; print "\nSQLite version: $ +sqliteversion\n"; $dbh->do("DROP TABLE IF EXISTS data") or print "drop table failed"; $dbh->do("CREATE VIRTUAL TABLE data USING fts4 (col1 TEXT, col2 TEXT, +tokenize=unicode61)") or print "failed to create fts4 table";

        Output:
        SQLite version: 3.8.0.2 DBD::SQLite::db do failed: unknown tokenizer: unicode61 at e:\uni612.p +l line 22. failed to create fts4 table
Re^4: Using the unicode61 tokenizer in DBD::SQLite
by walto (Pilgrim) on Jan 07, 2014 at 10:24 UTC
    Yes, according to DBD::SQLite it should work out of the box.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1069587]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (10)
As of 2014-12-21 16:19 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (106 votes), past polls