Nondeterministic Collations cause error on search bars #4877

murat.kebabci created 2 years ago

ABP Framework version: v6.0.3
UI type: Angular
DB provider: EF Core
Tiered (MVC) or Identity Server Separated (Angular): yes
Exception message and stack trace:
---------- Exception Data ---------- Severity = ERROR InvariantSeverity = ERROR SqlState = 0A000 MessageText = nondeterministic collations are not supported for substring searches File = varlena.c Line = 1209 Routine = text_position_setup
Steps to reproduce the issue:
Hello,
There is a filtering issue on administration pages that with search bar for the application that has a postgresql database. It causes error on the user interface when user wants to use search bar. In our application, we set the collation in filtering for such cases. Since ABP supports postgresql, can you fix related repository methods?

berkansasmaz created 2 years ago

Support Team .NET Developer

Unfortunately, this is Database Provider-specific and there is not much we can do about it.

See: https://support.abp.io/QA/Questions/3206/Error-when-filtering-data#answer-b2bfddfb-0e5b-68d9-802d-3a045a0b04c8

We recently migrated our own websites from MSSQL to PostgreSQL. That was one of the biggest challenges during the migration. My advice would be to use citext. See: https://blog.abp.io/abp/Migrating-from-MS-SQL-to-Postgresql