0
murat.kebabci created
- 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?
1 Answer(s)
-
0
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
