Submitted By: seesink
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:
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?
P.S. NOCASE would be nice too, but workaround with
UPPER works fine.