9/2/2023 0 Comments Mysql like case insensitive![]() ![]() But in current versions of postgresql all is running very fast so group 'can do' is growing. We afraid about impact on performance also, so we have stored list of fields where this logic can be used or can't be used (code,description, note and similliar fields are in can be group). The SEARCH_VALUE has to be passed to sql as parameteter not as String concatation. So in sql_like function in the code should be similiar: "unaccent(lower(" + KEY+ ")) LIKE unaccent(lower("+SEARCH_VALUE+"))" For nonbinary strings ( CHAR, VARCHAR, TEXT ), string searches use the collation of the comparison operands. Generating criterium for Like operator is done : Postgresql has extension unaccent with function unaccent(varchar) which we use for this issue.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |