title: How to use sqlite icu in like query
body: <p>hi I modified my sql statement as </p>
  
  <pre><code>CREATE VIRTUAL TABLE [v_fts] USING fts4 
  (
   [title], 
  tokenize=icu
  )" 
  </code></pre>
  
  <p>But when I am trying to insert data I am getting error <code>SQL logic error or missing database</code></p>
  
  <p><strong>Edit</strong></p>
  
  <p>I had compiled sqlite with icu option using -<code>DSQLITE_ENABLE_ICU</code> </p>
  
  <p>option. </p>
  
  <p>how to load icu ?</p>
  
  <p>I had uploaded shell code with makefile here </p>
  
  <p><a href="http://www.2shared.com/file/8hxA3KIn/sqlite.html" rel="nofollow">http://www.2shared.com/file/8hxA3KIn/sqlite.html</a></p>
  
  <pre><code>all: release32
  
  CFLAGS = -fPIC -O6 -DNO_TCL -DSQLITE_THREADSAFE=1 -DHAVE_USLEEP=1 -DSQLITE_ENABLE_FTS3=1  -O3 -Os  -I. -DSQLITE_ENABLE_ICU `/home/vivek/downloads/icu/des32/bin/icu-config --cppflags`
  
  export LDFLAGS += -Wl,--start-group 
  export LDFLAGS += /home/vivek/downloads/icu/des32/lib/libsicui18n.a
  export LDFLAGS += /home/vivek/downloads/icu/des32/lib/libsicuuc.a
  export LDFLAGS += /home/vivek/downloads/icu/des32/lib/libsicudata.a
  export LDFLAGS += -lcrypt -ldl -lz -lrt  -lssl -lpthread   
  export LDFLAGS += -Wl,--end-group
  
  OBJ=sqlite3.o\
      shell.o\
      icu.o\
  
  release32: $(OBJ)
       g++34  -fno-exceptions -fno-operator-names ${CFLAGS} -DNDEBUG -m32  -static  $(OBJ) $(LDFLAGS) -o s.out
  %.o:%.c
      gcc34 ${CFLAGS} -DNDEBUG -m32 -c    $&lt;
  </code></pre>
  
  <p>my query are </p>
  
  <pre><code>CREATE VIRTUAL TABLE [vivek_fts] USING fts4 ( [title],tokenize=icu en_US)
  insert into vivek_fts values("a");
  </code></pre>