[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