since I create some multi-language table - I want to allow finding unicode text
so I made the field:Key_Words" (ntext)
It will have a string that can include some words in different languages, so that I can find by using:
SELECT Key_Words FROM MyTable WHERE Key_Words LIKE '%" & MyVar & "%' "...
The problem is that I can not apply clustered index onntext field (or *any* index...)
Any ideas how to deal with it ?SQL Server "large" edition and full text search.
Only way.|||Thanks,
I was trying to avoid reading about this stuff...
but I guess there is no escape 4 me :-(
No comments:
Post a Comment