PostgreSQL nondeterministic collations are not supported for LIKE

15 votes

1 answer

15341 views

collation unicode postgresql-12 case-sensitive international-components-unicode

                          I am using Postgresql v12.
I created a collation like this:

    CREATE COLLATION ci (provider = icu, locale = 'tr_TR', deterministic = false);

I used that collation in a table: 

    create table testtable1 (
        id serial  primary key,
        name text  COLLATE "ci"
    );

And I inserted sample data:

    insert into testtable1 values(3,'abc');

When I query that table using LIKE, it returns the following error:

    select name from testtable1 WHERE name LIKE '%a%'  

> ERROR:  nondeterministic collations are not supported for LIKE  
> SQL state: 0A000

But I need to use LIKE. Is there any way to allow this?

Asked by Banu Akkus (389 rep)

Apr 29, 2020, 02:40 PM
Last activity: May 5, 2020, 04:47 PM

PostgreSQL nondeterministic collations are not supported for LIKE

Related Questions