Re: search strings using foreign characters
- From: "Damon" <damonf@xxxxxxx>
- Date: 19 Jul 2006 15:13:57 -0700
Dica wrote:
i've taken over a web app built by another developer. he was stripping out
special characters and replacing with standard ones when searching our
people table. for instance:
"é" was replaced with "e". this seemed to work fine and would return names
like 'Jose' as well as 'José'. as a matter of fact, 'é' doesn't even seem to
be recognized as a statement like 'select * from people where lastName like
'%é%' ' returns nothing. so, it seems like replacing é for e is the right
thing to do here.
however, he was also replacing "ã" with "a", but this character seems to be
different. if we replace "ã" with "a", i get no matches when searching for a
last name like "Simão".
anybody know why some of these characters are ignored while others aren't?
Dica,
I personally have not had to deal with this issue. However, I might
try replacing all the special characters with _. So you would have the
statement. select * from people where lastName like '%Sim_o%' This
will replace any single character.
Hope this helps.
Damon.
.
- Follow-Ups:
- Re: search strings using foreign characters
- From: Dica
- Re: search strings using foreign characters
- References:
- search strings using foreign characters
- From: Dica
- search strings using foreign characters
- Prev by Date: Re: Transaction Log File Size
- Next by Date: Re: Q: Help with dynamic SQL
- Previous by thread: search strings using foreign characters
- Next by thread: Re: search strings using foreign characters
- Index(es):
Relevant Pages
|
