Skip to content

Instantly share code, notes, and snippets.

@sixtus
Created July 5, 2012 11:24
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sixtus/3053123 to your computer and use it in GitHub Desktop.
Save sixtus/3053123 to your computer and use it in GitHub Desktop.
Compiling sqlite with ICU support
$ ./configure CFLAGS="-Os -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_ICU -DSQLITE_ENABLE_RTREE -DSQLITE_THREADSAFE=2 `icu-config --cppflags`" LDFLAGS="`icu-config --ldflags`" LIBS="-licudata -licui18n -licuio -licule -liculx -licutu -licuuc"
$ make -j4 && make install
$ sqlite3
sqlite> select icu_load_collation('de_DE', 'de_DE');
sqlite> create table t1(name collate de_DE);
sqlite> insert into t1 values('a'), values('ä'), values('o'), values('ö');
sqlite> select * from t1 order by name desc;
ö
o
ä
a
@javahanchao
Copy link

good

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment