You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
create collation PXW_CYRL_CI_AI for WIN1251
from PXW_CYRL
CASE INSENSITIVE
ACCENT INSENSITIVE;
with A(val) as(
select cast('update' as blob sub_type text) from rdb$database
union all
select 'UPDATE' from rdb$database
)
select * from A where val collate PXW_CYRL_CI_AI like '%update%'
Submitted by: Alex Bekhtin (afgm)
create collation PXW_CYRL_CI_AI for WIN1251
from PXW_CYRL
CASE INSENSITIVE
ACCENT INSENSITIVE;
with A(val) as(
select cast('update' as blob sub_type text) from rdb$database
union all
select 'UPDATE' from rdb$database
)
select * from A where val collate PXW_CYRL_CI_AI like '%update%'
FB 2.5 - two record
FB 3.0, 4.0 - only one record
Commits: 9951d94 fb40f1e
The text was updated successfully, but these errors were encountered: