Full Text in Portuguese

Hi,
I’m trying to use Full Text Index with Portuguese language. It seems to be
everything well configure in the SQL 2005 Server, but when I do queries to
the database it returns me values that contains Portuguese noise words (that
are included in the noise words file noisePTS.txt in the server). Any idea?
Thanks,
Rui ReisHello,
When you create full text index of table, did you choose Portuguese
language word breaker for indexed columns? If not, you may want to create
new catalog to test
Since the issue is related to specific local language, you may want to
contact local support for more qualified support. Please see
http://support.microsoft.com for regional support phone numbers.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a w to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/defaul...rnational.aspx.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||This seems odd to me. Granted, I have never used Full Text Indexing, but if
the character set is understood by the system, I don't see why the language
would make any difference. I would expect noise words to work the same,
regardless of the language.
Have you tested the noise words with any other language to determine that
this is indeed the problem? I would try some english noise words in a
custom noise file and see if you have the same issue. If you still have the
same issue, then you can pretty much conclude that the problem is with the
system configuration rather than the language.
"Tecnica" <abola@.nospam.nospam> wrote in message
news:95D051B8-D8B9-44D7-8839-C1088674ABF5@.microsoft.com...
> Hi,
> I'm trying to use Full Text Index with Portuguese language. It seems to be
> everything well configure in the SQL 2005 Server, but when I do queries to
> the database it returns me values that contains Portuguese noise words
(that
> are included in the noise words file noisePTS.txt in the server). Any
idea?
> Thanks,
> Rui Reis
>