I have a table in PostgreSQL:
Name:
------
bánh
banh
banh test
I search "bánh" or I search "banh", I want to return all of 3 rows above
In SQL Server, this script work
select * from digital d where d.title like '%banh%' COLLATE Vietnamese_CI_AI
But in postgreSQL it does not work. How do I write script in PostgreSQL?