On 18 Mar 2011, at 5:07am, ashish yadav wrote: > Can you please also provide some code sample for same ? > > i am not able to understand, your point "When a custom collation is > registered, it may indicate whether it wants its strings in UTF-8, UTF-16 or > either."
The ICU extension for SQLite does some of its work by defining a custom collation. You don't need to do this yourself, it's already in the code. So it will handle conversion between UTF formats itself. Just handle your strings as you normally would. There doesn't seem to be a page on www.sqlite.org about ICU. It would be nice to have some sample code. The best page so far seems to be http://www.sqlite.org/src/artifact?ci=trunk&filename=ext/icu/README.txt Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users