SFID: 853354#
Submitted By: seesink
Hello,
I am trying to do a query like
SELECT name FROM artist WHERE name LIKE '%BJORK%'
And trying to get BJ??RK as a result. Note the accent.
(And results like BJ??RK, BJORK etc. would also be valid)
If I am not mistaken I would need a collation for this,
but the closest thing I found is:
http://www.brookstonesystems.com
Which is nice, but not for linux and no unicode support.
Am I right that this would need a unicode NOACCENT
collation? If so this is my feature request.
Workarounds for the problem are highly aprecciated. Are
there other collations / charsets in firebird which do this?
Cheers,
Remco Seesink
P.S. NOCASE would be nice too, but workaround with
UPPER works fine.
New Feature
Closed
Major
accent ignoring collation for unicode
Sender: raseesink
Logged In: YES
user_id=669582
We solved this by filling a separate wordlist without accents which was
done mainly for speed with search and solves the accent problem in the
same time.
A word list can be searched by index using START WITH "BJORK"
instead of LIKE "%BJORK%". It is not the same but in our problem set
it generates even better result as you get less false (semantic) positives.
Disadvantage is duplicating data and risk getting out of sync.