[sqlite] Problem with LIKE and greek characters

[Robert Gdula]

Hi,

I've problem with greek characters when I'm using SQLite, it's no working,
but for English charaters is ok, problem it is only for LIKE, when I use
WHERE for greek characters it's working ok, how to resolve this problem ?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problem with LIKE and greek characters

[Dan Kennedy]

On 02/22/2012 03:53 PM, Robert Gdula wrote:

Hi,

I've problem with greek characters when I'm using SQLite, it's no working,
but for English charaters is ok, problem it is only for LIKE, when I use
WHERE for greek characters it's working ok, how to resolve this problem ?


SQLite's built-in LIKE operator only understands upper and lower case
equivalence for the 26 letters used in English.

If you need it to understand the upper/lower case relationships between
any other characters, either use the ICU extension or create your own
implementation of LIKE:

  http://www.sqlite.org/lang_corefunc.html#like

Dan.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problem with LIKE and greek characters

[Robert Gdula]

Thank you for the fast response, Mayby someone know any implementation of
LIKE, ICU function for UNICODE ?

W dniu 22 lutego 2012 10:15 użytkownik Dan Kennedy
napisał:

> On 02/22/2012 03:53 PM, Robert Gdula wrote:
>
>> Hi,
>>
>> I've problem with greek characters when I'm using SQLite, it's no working,
>> but for English charaters is ok, problem it is only for LIKE, when I use
>> WHERE for greek characters it's working ok, how to resolve this problem ?
>>
>
> SQLite's built-in LIKE operator only understands upper and lower case
> equivalence for the 26 letters used in English.
>
> If you need it to understand the upper/lower case relationships between
> any other characters, either use the ICU extension or create your own
> implementation of LIKE:
>
>  
> http://www.sqlite.org/lang_**corefunc.html#like
>
> Dan.
> __**_
> 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] Problem with LIKE and greek characters

[Igor Tandetnik]

Robert Gdula  wrote:
> Thank you for the fast response, Mayby someone know any implementation of
> LIKE, ICU function for UNICODE ?

http://www.sqlite.org/src/artifact?ci=trunk&filename=ext/icu/README.txt

-- 
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problem with LIKE and greek characters

[Robert Gdula]

I'm trying to add ICU to my Sqlite static library, compilation is ok, and I
have file of library, but when I try to use it I've got some errors,
anybody can help me what I do wrong ?

..\..\Library\SQLCIPHER\libSQLCIPHER.a(SqlCipher.o):SqlCipher.c|| undefined
reference to `ucol_strcoll_3_8'|
..\..\Library\SQLCIPHER\libSQLCIPHER.a(SqlCipher.o):SqlCipher.c|| undefined
reference to `_imp__utf8_countTrailBytes_3_8'|
..\..\Library\SQLCIPHER\libSQLCIPHER.a(SqlCipher.o):SqlCipher.c|| undefined
reference to `_imp__utf8_countTrailBytes_3_8'|
..\..\Library\SQLCIPHER\libSQLCIPHER.a(SqlCipher.o):SqlCipher.c|| undefined
reference to `u_foldCase_3_8'|
..\..\Library\SQLCIPHER\libSQLCIPHER.a(SqlCipher.o):SqlCipher.c|| undefined
reference to `u_foldCase_3_8'|
..\..\Library\SQLCIPHER\libSQLCIPHER.a(SqlCipher.o):SqlCipher.c|| undefined
reference to `_imp__utf8_countTrailBytes_3_8'|
..\..\Library\SQLCIPHER\libSQLCIPHER.a(SqlCipher.o):SqlCipher.c|| undefined
reference to `_imp__utf8_countTrailBytes_3_8'|
..\..\Library\SQLCIPHER\libSQLCIPHER.a(SqlCipher.o):SqlCipher.c|| undefined
reference to `_imp__utf8_countTrailBytes_3_8'|
..\..\Library\SQLCIPHER\libSQLCIPHER.a(SqlCipher.o):SqlCipher.c|| undefined
reference to `u_errorName_3_8'|
..\..\Library\SQLCIPHER\libSQLCIPHER.a(SqlCipher.o):SqlCipher.c|| undefined
reference to `u_strToUpper_3_8'|
..\..\Library\SQLCIPHER\libSQLCIPHER.a(SqlCipher.o):SqlCipher.c|| undefined
reference to `u_strToLower_3_8'|
..\..\Library\SQLCIPHER\libSQLCIPHER.a(SqlCipher.o):SqlCipher.c|| undefined
reference to `uregex_setText_3_8'|
..\..\Library\SQLCIPHER\libSQLCIPHER.a(SqlCipher.o):SqlCipher.c|| undefined
reference to `uregex_matches_3_8'|
..\..\Library\SQLCIPHER\libSQLCIPHER.a(SqlCipher.o):SqlCipher.c|| undefined
reference to `uregex_setText_3_8'|
..\..\Library\SQLCIPHER\libSQLCIPHER.a(SqlCipher.o):SqlCipher.c|| undefined
reference to `uregex_open_3_8'|
..\..\Library\SQLCIPHER\libSQLCIPHER.a(SqlCipher.o):SqlCipher.c|| undefined
reference to `ucol_open_3_8'|
..\..\Library\SQLCIPHER\libSQLCIPHER.a(SqlCipher.o):SqlCipher.c|| undefined
reference to `ucol_close_3_8'|
..\..\Library\SQLCIPHER\libSQLCIPHER.a(SqlCipher.o):SqlCipher.c|| undefined
reference to `utf8_nextCharSafeBody_3_8'|
..\..\Library\SQLCIPHER\libSQLCIPHER.a(SqlCipher.o):SqlCipher.c|| undefined
reference to `ucol_close_3_8'|
..\..\Library\SQLCIPHER\libSQLCIPHER.a(SqlCipher.o):SqlCipher.c|| undefined
reference to `uregex_close_3_8'|
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problem with LIKE and greek characters

[Igor Tandetnik]

Robert Gdula  wrote:
> I'm trying to add ICU to my Sqlite static library, compilation is ok, and I
> have file of library, but when I try to use it I've got some errors,
> anybody can help me what I do wrong ?
> 
> ..\..\Library\SQLCIPHER\libSQLCIPHER.a(SqlCipher.o):SqlCipher.c|| undefined
> reference to `ucol_strcoll_3_8'|

I imagine you would also need to link to whatever library comes with ICU.
-- 
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users