Re: Unicode aware COLLATION in QSQLITE

[ancode tran]

marco bubke wrote:
> Hi
>
> What is the best way to do Unicode aware COLLATION in sqlite. Is there
> a easy way which is working with qt out of the box(use Qt function for
> comparision)?
>
> Thanks and regards
>
> Marco
 

I think you should build sqlite with ICU for collation support.

 

1. Download sqlite (www.sqlite.org, current version is 3.4.2) and unpack it to somewhere.

 

2. Download ICU (International Components for Unicode). ICU is available at http://www.icu-project.org.

 

Please read the file named "readme.txt" in sqlite-version/ext/icu for more details (sqlite-version is sqlite root folder and version can be "3.4.2", for example).

 

I hope this will help.

 

---

Hái, ÄÃp và kát nái vái cÆ dÃn máng trÃn Yahoo! Hái & ÄÃp