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" <[email protected]> Do: <[email protected]> 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]
