Re: [sqlite] More on ICU extension (windows)
Hello! В сообщении от Saturday 02 August 2008 13:59:54 Graeme написал(а): > > and in file mksqlite3c.tcl add icu.c in "foreach file" circle before > > main.c > > Thanks Alexey, it worked fine. I would never have thought to change > mksqlite3c.tcl, so thanks especially for that. I did create ticket 3245 "ICU extension compilation" some days ago but it isn't closed now. See http://www.sqlite.org/cvstrac/tktview?tn=3245 Best regards, Alexey. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] More on ICU extension (windows)
On Friday 01 August 2008 17:37:51 Alexey Pechnikov wrote: > > And how about SQLite+ICU compilation? Is it work for you? > > In configure.in > > TCC += -DSQLITE_ENABLE_ICU=1 `icu-config --ldflags` > LIBOBJ += icu.lo > > icu.lo: $(TOP)/ext/icu/icu.c $(HDR) > $(LTCOMPILE) -c $(TOP)/ext/icu/icu.c > > and in file mksqlite3c.tcl add icu.c in "foreach file" circle before main.c > Thanks Alexey, it worked fine. I would never have thought to change mksqlite3c.tcl, so thanks especially for that. I can see why ICU is left out of the downlodable binaries: the vmsize is much bigger with it. It is OK for my puposes, but I can see why many people would not want it. Graeme ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] More on ICU extension (windows)
On Friday 01 August 2008 19:59:16 Alexey Pechnikov wrote: > Hello! > > > And how about SQLite+ICU compilation? Is it work for you? Not yet, but I will try to solve the problems myself before asking for more help. > > > > In configure.in > > I'm sorry, in Makefile.in, of cource I was about to ask > I think that debian mantainer of libicu using some patches for it. May be > I'll find solution in patches for debian package. So it is an ICU problem? Have to go now, will let you know how things go with compiling. Graeme -- Graeme Pietersz http://moneyterms.co.uk/ http://pietersz.co.uk/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] More on ICU extension (windows)
I don't think the sqlite3.exe command-line tool converts its input strings to utf8 before parsing them. I think its because non-Windows platforms have utf8 console sessions, and Windows consoles use the default Windows codepage. So when you're inserting from the console, you're inserting codepage-specific text rather than utf8 text. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christophe Leske Sent: Friday, August 01, 2008 3:05 AM To: General Discussion of SQLite Database Subject: [sqlite] More on ICU extension (windows) Graeme schrieb: > I apparently successfully compiled the ICU extension with: > Has anyone sucessfully compiled the ICU extension for Windows (XP)? If so, i would be very interested in the steps, thank you. Also, isn´t it that the command line interpreter for windows (the one offered at the sqlite site) should have the ICU extension built-in? If so, then i must say that it apparently hasn´t, as i cannot do any SQL statements in it whatsoever. Any diacritic character like "ü" gets apparently garbled in the statements. I am doing something like this select * from cities where name like "münchen"; --> no result whereas if i do select * from cities where name like "m³nchen"; --> correct results Note the weird "upper 3" character in the request, which apparently represents the Umlaut "ü". Either the command line interpreter does not correctly handle diacritic characters, or my sqlite database was wrongly created (it was an automatic conversion from an Access MDB file thought). Thanks for any help, -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] More on ICU extension (windows)
Hello! > > And how about SQLite+ICU compilation? Is it work for you? > > In configure.in I'm sorry, in Makefile.in, of cource. > > TCC += -DSQLITE_ENABLE_ICU=1 `icu-config --ldflags` > LIBOBJ += icu.lo > > icu.lo: $(TOP)/ext/icu/icu.c $(HDR) > $(LTCOMPILE) -c $(TOP)/ext/icu/icu.c > > and in file mksqlite3c.tcl add icu.c in "foreach file" circle before main.c On mswin (with -DU_UTF8_IMPL and U_EXPORT is replaced by U_EXPORT2) SQLite+ICU is compiled but returning error on command SELECT icu_load_collation('ru_RU', 'russian'); I think that debian mantainer of libicu using some patches for it. May be I'll find solution in patches for debian package. Best regards, Alexey. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] More on ICU extension (windows)
Hello! В сообщении от Friday 01 August 2008 15:49:40 Graeme написал(а): > On Friday 01 August 2008 16:45:54 Alexey Pechnikov wrote: > > Hello! > > > > В сообщении от Friday 01 August 2008 14:49:04 Alexey Pechnikov написал(а): > > > Try this > > > http://dload.mobigroup.ru/sqlite-ext/icu/3.5.9/libSqliteIcu.dll > > --snip-- > > > sqlite> SELECT load_extension('libSqliteIcu.dll'); > > SQL error: error during initialization: > > sqlite> .load 'libSqliteIcu.dll' > > sqlite> > > --snip-- > > > from utf8.h from icu package. I replace U_EXPORT to U_EXPORT2 and now > > libSqliteIcu.dll is compiled but it's not correct way. > > looks like a smimilar problem. It also looks to me like debugging this > would be difficult > > Graeme And how about SQLite+ICU compilation? Is it work for you? In configure.in TCC += -DSQLITE_ENABLE_ICU=1 `icu-config --ldflags` LIBOBJ += icu.lo icu.lo: $(TOP)/ext/icu/icu.c $(HDR) $(LTCOMPILE) -c $(TOP)/ext/icu/icu.c and in file mksqlite3c.tcl add icu.c in "foreach file" circle before main.c Best regards, Alexey. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] More on ICU extension (windows)
On Friday 01 August 2008 16:45:54 Alexey Pechnikov wrote: > Hello! > > В сообщении от Friday 01 August 2008 14:49:04 Alexey Pechnikov написал(а): > > Try this > > http://dload.mobigroup.ru/sqlite-ext/icu/3.5.9/libSqliteIcu.dll --snip-- > sqlite> SELECT load_extension('libSqliteIcu.dll'); > SQL error: error during initialization: > sqlite> .load 'libSqliteIcu.dll' > sqlite> --snip-- > > from utf8.h from icu package. I replace U_EXPORT to U_EXPORT2 and now > libSqliteIcu.dll is compiled but it's not correct way. > looks like a smimilar problem. It also looks to me like debugging this would be difficult Graeme -- Graeme Pietersz http://moneyterms.co.uk/ http://pietersz.co.uk/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] More on ICU extension (windows)
Hello! В сообщении от Friday 01 August 2008 14:49:04 Alexey Pechnikov написал(а): > Try this > http://dload.mobigroup.ru/sqlite-ext/icu/3.5.9/libSqliteIcu.dll sqlite3 :memory: SQLite version 3.5.9 Enter ".help" for instructions sqlite> SELECT load_extension('libSqliteIcu.dll'); SQL error: error during initialization: sqlite> .load 'libSqliteIcu.dll' sqlite> Now I'm thinking why "SELECT load_extension('libSqliteIcu.dll');" doesn't work... I'm using this command line for MinGW C:\MinGW\bin\gcc.exe -shared icu.c -lm -L. -LC:/icu-3.8/lib/ -licuin -licuuc -licudt -o libSqliteIcu.dll -l advapi32 -IC:/icu-3.8/include -I. -IC:\sqlite3-3.5.9\src There is the problem with #ifdef U_UTF8_IMPL U_EXPORT const uint8_t #elif defined(U_STATIC_IMPLEMENTATION) || defined(U_COMMON_IMPLEMENTATION) U_CFUNC const uint8_t #else U_CFUNC U_IMPORT const uint8_t /* U_IMPORT2? */ /*U_IMPORT*/ #endif utf8_countTrailBytes[256]; from utf8.h from icu package. I replace U_EXPORT to U_EXPORT2 and now libSqliteIcu.dll is compiled but it's not correct way. Best regards, Alexey. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] More on ICU extension (windows)
Hello! В сообщении от Friday 01 August 2008 14:05:09 Christophe Leske написал(а): > Graeme schrieb: > > I apparently successfully compiled the ICU extension with: > > Has anyone sucessfully compiled the ICU extension for Windows (XP)? If > so, i would be very interested in the steps, thank you. > > Also, isn´t it that the command line interpreter for windows (the one > offered at the sqlite site) should have the ICU extension built-in? > > If so, then i must say that it apparently hasn´t, as i cannot do any SQL > statements in it whatsoever. > > Any diacritic character like "ü" gets apparently garbled in the statements. > > > I am doing something like this > > select * from cities where name like "münchen"; --> no result > > whereas if i do > > select * from cities where name like "m³nchen"; --> correct results > > Note the weird "upper 3" character in the request, which apparently > represents the Umlaut "ü". > > Either the command line interpreter does not correctly handle diacritic > characters, or my sqlite database was wrongly created (it was an > automatic conversion from an Access MDB file thought). > > Thanks for any help, Try this http://dload.mobigroup.ru/sqlite-ext/icu/3.5.9/libSqliteIcu.dll Best regards, Alexey. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users