Project Home
Project Home
Documents
Documents
Wiki
Wiki
Discussion Forums
Discussions
Project Information
Project Info
Forum Topic - Regarding libqdb_cldr: (4 Items)
   
Regarding libqdb_cldr  
Hello all,

We would like to enable the mme support for setting the language for sorting data retrieved by SQL select statements. 
According to the mme config guide a library called libqdb_cldr.so is needed. We have a few questions regarding this 
library:

1. Where do we find this library? The guide says that it comes along with the files for language sorting included with 
the mme release but we could not find it.

2. Is this library based on standard ICU (as found on icu-project.org), if yes, what version?

3. Would it be possible to build our own libqdb_cldr using the latest official version of ICU?

Thanks in advance.

Best regards
Mike
Re: Regarding libqdb_cldr  
 > 1. Where do we find this library? The guide says that it comes along with the 
> files for language sorting included with the mme release but we could not find
>  it.

It isn't in the product shiplist (I don't know why). This means it won't be in the Aviage release, but here is a link to
 the foundry 27 release that should still work: 
http://community.qnx.com/integration/viewvc/viewvc.cgi/trunk/services/qdb/cldr/?root=multimedia&system=exsy1001

If you check out the multimedia source following the documentation in the multimedia project, you should be able to build it.
 
> 2. Is this library 
based on standard ICU (as found on icu-project.org), if yes
> , what version?

No. It is based on a standard UCA (Unicode Collation Algorithm). http://www.unicode.org/reports/tr10/#Introduction
 
> 3. Would it be possible to build our own libqdb_cldr using the latest official
>  version of ICU?

It doesn't use ICU. But using the sourcecode on foundry 27 (even though it is based on our trunk, QDB/Sqlite has not has
 any big changes since Aviage 1.2) you could build libqdb_cldr yourself, or use it as a base for a different collation 
algorithm.


Regards,
Gilles

Re: Regarding libqdb_cldr  
Sorry, just further information. Maybe you don't care about libqdb_cldr.so at all, you just want ICU support in SQLite 
to do things like case insensitive matching, etc. You can also do this by building the ICU library for QNX. Then you can
 download and build an ICU extension from the sqlite.org website:
http://www.sqlite.org/cvstrac/dir?d=sqlite/ext/icu

Then, check out the sqlite3 source code from the foundry 27 Multimedia project and rebuild ti with "SQLITE_ENABLE_ICU" 
defined. 

Regards,
Gilles
Re: Regarding libqdb_cldr  
Thanks a lot for this information. I will try both ways, builtin uca and icu later on. Thanks again.

Regards
Mike