main logo
Subject: Re: [SQL] Search ignoring extended characters
Author: jda
Posted: 2002/06/29 15:20:47
 
View Entire Thread
New Search


>>>
>>>
>>>In RegEx this should be possible, but in indexed-by-word fields???
>>
>>I think no since it not work for you.
>
>
>It does work. Index-based search handles extended characters like
>their base character. So searching for e does also find =E9, and
>searching for =E9 does also find e. Works also with Umlauts =E4=F6=FC.
>

Hm, I have a db in which one record contains the name

Grassi

and another record contains the name

Gr=E4ssi //a with an umlaut, in case it doesn't come across in the email.


I just do this search (in RB, if that matters):

select id,authors,title,date,hit from references where
(left(authorsMethod, 1) =3D 'GRASSI') order by id

and got one hit.

I then did this search

select id,authors,title,date,hit from references where
(left(authorsMethod, 1) =3D 'GR=C4SSI') order by id

and got the *other* hit.

=46YI, authorsMethod is

authorsMethod =3D new VText("authorsMethod", 128, "English", kV_IndexByWo=
rds)
authorsMethod.SetMethod("Upper(authors)")


See anything wrong?

Jon
 
©2002 jda
<-- Prior Message New Search Next Message -->