Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
Add a reply View Replies (4)

Resolved case sensitive select

  1. Roger
    Roger
  2. Valentina Database ADK
  3. Monday, August 10 2020, 01:54 AM
  4.  Subscribe via email
Hello

I try to select caseinsensitve. (Enter hello and find Hello)

I used Call db.SqlExecute("SET PROPERTY IdentsCaseSensitive OF DATABASE TO True";) And I see the change in the database properties. I tried to set False too. (restartet the server)

In the select I use iLike and triede with Like too.

But I never found my serach word with caseinsensitvity. What more con I do?

Regards Roger
  1. Valentina DB ADK
  2. SOLVED!
Comment
There are no comments made yet.
Responses (4)
François Van Lerberghe
François Van Lerberghe Accepted Answer
Indeed, IMHO could be better explained in the doc.
You can use REGEX operator
* Contain 'C' :


SELECT myFieldName FROM myTableName WHERE myFieldName REGEX 'C'

* Start with 'C' :


SELECT myFieldName FROM myTableName WHERE myFieldName REGEX '\AC'

* End with 'C' :


SELECT myFieldName FROM myTableName WHERE myFieldName REGEX 'C\Z'

* Contain 'C' or 'c' (case insensitive :


SELECT myFieldName FROM myTableName WHERE myFieldName REGEX '(?i)c'
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 1
Ivan Smahin
Ivan Smahin Accepted Answer
https://valentina-db.com/docs/dokuwiki/v10/doku.php?id=valentina:vcomponents:vkernel:locale:locale&;s[]=ksecondary

The most interesting for developer is attribute kStrength. There are the following values for this attribute:

kPrimary = 0 - ignore accents and case role = Role = rôle
kSecondary = 1 - ignore case but differ accents role = Role < rôle
kTertiary = 2 - differ case and accents role < Role < rôle



roperties:db_props&" target="_blank" rel="nofollow">https://valentina-db.com/docs/dokuwiki/v10/doku.php?id=valentina:vcomponents:vsql:reference:properties:db_props&;s[]=strength#strength



SET PROPERTY Strength of database to 'kSecondary';
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 2
Ivan Smahin
Ivan Smahin Accepted Answer
IdentsCaseSensitive is about names of schema objects like tables, fields ....

https://valentina-db.com/docs/dokuwiki/v10/doku.php?id=valentina:vcomponents:vkernel:database_identifiers_case_sensitive&;s[]=identscasesensitive
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 3
Roger
Roger Accepted Answer
Thaks Françoise is a good idea for many solutions. Many thanks for your examples.

Many thaks Ivan, works fine like I had hoped.

Have a nice day Roger
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 4
  • Page :
  • 1


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