Turn on Diacritics-sensitive search for WSS 3.0

Question

Hello:

Without getting too much into the weeds, I'm attempting to turn on diacritics-sensitive search in WSS 3.0 SP2, on my one application machine running Windows Server 2003 R2 Enterprise SP2. There doesn't seem to be an operator to do this, is there?

Here is my output:

C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>stsa
dm -o spsearch -action list

Farm service account: jdcwin\testpwa_wsearch
Farm content access account: jdcwin\testpwa_waccess
Farm performance level: Maximum

*DCSPDEVAPP001:
  Status: Online
  Default index location: C:\Program Files\Microsoft Office Servers\12.0\Data\A
                          pplications
  Index location: C:\Program Files\Microsoft Office Servers\12.0\Data\Applicati
                  ons
  Search database server: DCSPDEVSQL010
  Search database name: SharePoint_DEV_Search_2009103001
  SQL authenticated database user:
  Diacritics-sensitive search: Off
  Content databases indexed by DCSPDEVAPP001:
    Server: DCSPDEVSQL010
      SharePoint_AdminContent_4db31817-ddab-492b-89b4-7c52301ed066
      DEV_OCAEPA_Content_5002

Answer 1

Adding Search Server 2008 Express on top of WSS 3.0 will give you more search options (don't chose the default "use the existing site" in the installation but create a new one) than the basic search List or Site in WSS 3.0.

(Roughly equivalent to MOSS search without People Search).

But as I haven't a clue what a diacritics-sensitive search is I can't say whether it includes that. Somehow I doubt it.

---

FAQ sites: (SP 2010) http://wssv4faq.mindsharp.com; (v3) http://wssv3faq.mindsharp.com and (WSS 2.0) http://wssv2faq.mindsharp.com
Complete Book Lists (incl. foreign language) on each site.

Answer 2

Hi,

You can use the operation “Spsearchdiacriticsensitive” to enable or disables the diacritic sensitivity setting in Wss3.0.

For more information about this Stsadm operation, please refer to: http://technet.microsoft.com/en-us/library/cc287887.aspx

Hope it helps.

---

Xue-Mei Chang

Answer 3

Thank you Xue-Mei, this did solve my issue.

Thank you Mike, for your answer. To reply, we are also using Microsoft Office Project Server 2007, without MOSS, in our production environment, so we are not able to install SSE.

Looking forward to 2010!