Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 finding word on string containing international characters

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-03-25 : 13:15:11
Carlos writes "Hi!
First of all, great site (you must have heard that before...). Straight to the point.
I got a news db with the normal stuff. Topic, heading, body, links, etc.

Well, some articles are in spanish, and most of the authors use the correct punctuation allways, not as most mortals.

As an example on the body column a text says something like this.. " y J. J. Benítez respondió a la consulta ... "

Well, If I search for "Benítez", everything works fine, but searching for "Benitez" fails for i = í is false.

A global search and replace would be the first aproach, but I guess someone would have stumbled over this before... I don't want to re-discover fire.

Any advice?
Thanks

Carlos Troncoso"
   

- Advertisement -