[V4RB] Accents in queries

[Frank Bitterlich]

Did you set the language of the field correctly? If so, it should handle
all variations of characters - uppercase, lowercase, and with diacritics
- E = e = é = è = ê etc.

Cheers,
   Frank+++

Wonder Fef wrote:
> 
> Hello all,
> 
> I have a SQLSelect statement:
> 
> Dim cursor as Vcursor
> 
> Cursor = myDatabase.SQLSelect("Select Name from myTable where Name like
> 'premiere' no_case")
> 
> The cursor gives me access to all matching rows, excepting rows containing
> "première", which is bad for my use.
> 
> I looked into the RegEx documentation but I can't understand how to use the
> directives.
> 
> Any help will be highly appreciated.
> Thanks
> Eric

--
Günter Schmidt & Co. oHG         
Frank Bitterlich             eMail: bitterlich at gsco.de
Schlosserstr. 4              WWW:   http://www.gsco.de/gsco
D-60322 Frankfurt            Tel.:  069 / 156809-29
GERMANY                      Fax:   069 / 156809-28