1. Helge Tjelta
  2. Valentina Database ADK
  3. Samstag, November 25 2017, 09:37 AM
  4.  Abonnieren via E-Mail
Hi, collation is set to primary
search is done like:
WHERE Kunde->navn LIKE '%dnb%'

Record wanted to get is "DNB", but for this to work I need to remove the first %, so 'dnb%' will get the "DNB" record...
But if i want to get record "Kulturkirken Jakob - Oslo" and search for LIKE 'Jakob%" I get nothing... I have to start with 'Kultur...'

So how kan I really have a match/contain... that can do both...

shouldn't '%dnb%' give me record with "DNB" in it ?
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
Hi Helge,

please notice that exists LIKE and ILIKE.

LIKE is about 3 times faster, but uses the simple strcmp(), ignores collators
ILIKE use collators.

So please check this point and let us know if this helps
Kommentar
There are no comments made yet.
  • Seite :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories