Hi there,

ran into the same issue - Error:
/usr/lib/x86_64-linux-gnu/sqlite/icu.so: undefined symbol: ucol_close_76

as ucol_close gets defined in /usr/include/unicode/ucol.h from 
https://packages.debian.org/trixie/libicu76-dev I installed that
package (and libicu76 as well) and then tried recompiling the
debian package while messing with CPATH/LDPATH - no success, will have
to keep on using the sqlite with icu compiled in for the moment :/

since you probably can use ext-icu atm to compile other packages like in
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=758985 the most
straightforward testcase would be to open sqlite3 cli and try

sqlite> .load /usr/lib/x86_64-linux-gnu/sqlite/icu
or
sqlite> SELECT load_extension('/usr/lib/x86_64-linux-gnu/sqlite/icu');
directly, both fail with "undefined symbol: ucol_close_76" here on up
to date trixie

thanks for the work on proper packaging the sqlite-icu extension! using
sqlite to work with i18n user data is quite common on android, easily
activating the same featureset on debian would really be nice.

if I can assist in testing, please let me know

Cheers,
Jasper

Reply via email to