Hi,

In test 4you compare lower letter "f" with upper letter "F" then you got difference.
All is ok in this test case

Regards,
Karol Bieniaszewski

----- Reply message -----
Od: "Stefan Heymann" <lists@...>
Do: <firebird-support@yahoogroups.com>
Temat: [firebird-support] Problem with Sharp s and UNICODE_CI_AI
Data: śr., maj 22, 2013 14:56


OK, I have found a simpler way to show my problem.

Try this on a UTF8 database:

select
case when 'Übergeek' collate unicode_ci_ai like 'ÜB%' collate unicode_ci_ai
then '=' else '<>' end as test_1,
case when 'Übergeek' collate unicode_ci_ai like 'üb%' collate unicode_ci_ai
then '=' else '<>' end as test_2,
case when 'Fußball' collate unicode_ci_ai like 'fu%' collate unicode_ci_ai
then '=' else '<>' end as test_3,
case when 'Fußball' collate unicode_ci_ai like 'fuß%' collate unicode_ci_ai
then '=' else '<>' end as test_4,
case when upper ('Fußball') like upper ('fuß%')
then '=' else '<>' end as test_5
from rdb$database

TEST_4 will show a mismatch, which is wrong.

Is this a bug? What can I do to get a case and accent insensitive
comparison?

Database: Firebird 2.5.2.26540 SuperServer 64-Bit
OS: Windows 7 Pro 64-Bit


Regards

Stefan






------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links





[Non-text portions of this message have been removed]