nalgeon/sqlean 0.25.0

on GitHub

Unicode-aware case functions in the text extension. Powered by stc from @tylov. Thank you, Tyge!

⚠️ The unicode extension is now deprecated and will be removed in future releases. Use the text extension instead.

text_upper

Transforms a string to upper case.

select text_upper('cómo estás');
-- CÓMO ESTÁS

text_lower

Transforms a string to lower case.

select text_lower('CÓMO ESTÁS');
-- cómo estás

text_title

Transforms a string to title case.

select text_title('cómo estás');
-- Cómo Estás

text_like

Reports whether a string matches a pattern using the LIKE syntax.

select text_like('cóm_ está_', 'CÓMO ESTÁS');
-- 1

select text_like('ça%', 'Ça roule');
-- 1

text_nocase

The text_nocase collating sequence compares strings without regard to case.

select 1 where 'cómo estás' = 'CÓMO ESTÁS';
-- (null)

select 1 where 'cómo estás' = 'CÓMO ESTÁS' collate text_nocase;
-- 1