[V4RB] RegEx search and UTF-8

Eric Ferrer wonderfef at noos.fr
Fri Jul 23 10:01:05 CDT 2004


> Especially look for
> DefineEncodings in your SQLSelect, e.g. "SELECT * FROM Table WHERE
> MyField='"+defineEncoding(mysearchstring,encodings.UTF8)+"'". It's
> something you easily miss.
Yes, I've done this.
By the way:
SELECT * FROM table WHERE Name LIKE 'boréales' NO_CASE
 finds the records 'Boréales'

The trouble is not there.
I do need my app to be very permissive considering eéêëôö, etc.
This still works with Unicode :
SELECT * FROM table WHERE Name LIKE 'bor[eéèêë]' no_case
But this not :
SELECT * FROM table WHERE Name LIKE 'bor[eéèêë]ales' no_case

Why ?
Eric



More information about the Valentina mailing list