SELECT myFieldName FROM myTableName WHERE myFieldName REGEX 'C'

SELECT myFieldName FROM myTableName WHERE myFieldName REGEX '\AC'

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

SELECT myFieldName FROM myTableName WHERE myFieldName REGEX '(?i)c'

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:referenceroperties:db_props&

SET PROPERTY Strength of database to 'kSecondary';