1. Roger
  2. Valentina Database ADK
  3. Montag, August 10 2020, 01:54 AM
  4.  Abonnieren via E-Mail
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
Kommentar
There are no comments made yet.
François Van Lerberghe Akzeptierte Antwort
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'
Kommentar
There are no comments made yet.
Ivan Smahin Akzeptierte Antwort
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';
Kommentar
There are no comments made yet.
Ivan Smahin Akzeptierte Antwort
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
Kommentar
There are no comments made yet.
Roger Akzeptierte Antwort
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
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