Modifying the database for non-English searches
To enable the MediaFrame database to allow searches in languages such as Chinese, the database needs to be modified. Because it will take some time to re-index the data, this procedure should be performed when the system is not in prime use. This procedure will not affect operations aside from search functionality.
- Open the Microsoft SQL Server Management Studio tool.
- Open Databases | MediaFrame | Tables nodes.
- Right-click the dbo.MetadataTbl table and select Full-Text Index | Properties. The Full-Text Index Properties dialog box opens.
- Select the Columns page.
- For every column that has a check box, change the language in the Language for Word Breaker column to the appropriate language.
- Once all the values are correct, click OK.
The indexes rebuild with the new word breaker.