How words break in the full text indexing process depends on what language you use, right? Now let's say I want to add a breaking character that usually is not, in any language.
Example:
I want words to break at the letter a how do I accomplish that? And let's also say I have a word that I want to act as a wordbreaker, for example the word space.
to clarify:
Iawantspacethis sentence tospacebreak
Should result in these words being indexed:
- I
- want
- this
- sentence
- to
- break
How do I accomplish this behavior in SQL 2005 FTS? If it's even possible?