"itamar" <itamar_zik@hotmail.com> wrote in message
news:cbbe01c3ba52$5abc7290$a601280a@phx.gbl...
> hi all
> i ma developing on an sql 2000 / win 2000 platform.
> i have built a table which contains a data in a unicode
> format..ie:"&#1077;&#1082;&#1076;&#1086;&#1090;&#1099;..."
> (this specific data is in russian). i have full text
> indexed the table (Neutral "Language for Word Breaker"). i
> have noticed very odd search results for example:
> i)when i search for "&#1079;&#1085;&#1072" i get results
> which contains this sequence but also results that have
> the sequence seperated by a space ie:&#1079;&#1085;
> &#1072;&#1082;&#1072;&#1085"
> ii)when i search for "&#1079;&#1085;&#1072;&#1082;&#1072"
> or for "&#1079;&#1085;&#1072;&#1082;" i will get similar
> results.
> can anyone light my way???? thanx,itamar

"itamar zik" <itamar_zik@hotmail.com> wrote in message
news:Oa4EvLJvDHA.1744@TK2MSFTNGP12.phx.gbl...
>
> hi John
> thank you for your reply...i am using nvarchar defined field , but
> somehow the data in it ,which is fed in through asp forms & vb dll, is
> being stored as numbers : &#num;&#num;&#num;...the munbers are the
> unicode values of the letters.....when i query the field with a
> character string ( which also turns to look like :";&#num;&#num;"...i
> get the funny results which do not change if i prefix "N" befor
> it....may be i have got it all wrong???
> thanx,itamar
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!