Ends in:
1 DAY
23 HRS
20 MIN
48 SEC
Ends in:
1 D
23 H
20 M
48 S
Open Closed

Nondeterministic Collations cause error on search bars #4877


User avatar
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)
  • User Avatar
    0
    berkansasmaz created
    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

Made with ❤️ on ABP v9.1.0-preview. Updated on December 02, 2024, 12:35