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 ?
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
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.


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