Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Full-text search and Collations

Status
Not open for further replies.

Syl20

Programmer
May 18, 2004
1
FR
Hello,

I try to install WSS (without portal server) for a french use.
The problem is that users, when they try to do a full text search for the word "étude", want to have results for documents named "etude" (without any accent).

This works well on english versions of WSS ; a look to SQL server databases shows that the general collation is accent insensitive(ai).
A french installation turns it to accent sensitive.

I copy the original configuration database to an another one, with the good collations. Despite this, all columns of each tables keeps the original collation. As a matter of fact, the search does not work as I wish. Do you see how I can do have results I expected ?

Hope you can help me !
Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top