Forum Moderators: open

Message Too Old, No Replies

Full-text Indexing And Foreign Characters

Has anyone done this successfully?

         

ratebeer

10:22 pm on Mar 10, 2005 (gmt 0)

10+ Year Member



I've got a normal string search and wanted to improve performance by utilizing MS's full-text indexing.

Because our site features beers from around the world, we have plenty of non-U.S. characters, so a search for "beer" is coded as

SELECT * FROM Beer WHERE BeerName LIKE '%b[eéêëè][eéêëè]r%'

but when I try

SELECT * FROM Beer WHERE CONTAINS(BeerName, 'b[eéêëè][eéêëè]r')

I get
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error occurred near '['. Expected ''''' in search condition 'fr[aáâãäåæ][nñ]k'

Smart people, please enlighten me!

ratebeer

12:20 am on Mar 11, 2005 (gmt 0)

10+ Year Member



One solution I got is to create another Name table that is all UTF (translate all the foreign characters) and then catalog and search on that.