DocuShare relies on the linguistic sort order of the database to display the Collection content lists in alphabetic order and how to change the linguistic sort order varies depending on the database connected to DocuShare.
Different languages have different sort orders for example:
· The Sort order can be case sensitive or insensitive
· Sort orders can ignore or consider diacritics (The marks near or through characters affecting the sound of the character)
To Change the Linguistic Sort Order in Oracle:
Note: You must be an Administrator to perform this solution.
1. Stop DocuShare
2. Open the <dshome>\config\jdbcpropertybean.properties file in a text editor.
Where <dshome> is replaced with the installation path for DocuShare. Depending on your installation environment this path may vary. The default installation path is C:\Xerox\Docushare.
3. Search for the url= entry
4. Change the entry to the desired linguistic setting. (see examples below)
Note: An Oracle Database has a default of Binary.
French Linguistic Sort Order
url=jdbc\:docushare\:oracle\://xerox.com\:1521;SID\=DOCSH;InitializationString=(alter session set NLS_SORT=french)
Canadian French sort with support for reverse secondary, special expanding characters
url=jdbc\:docushare\:oracle\://xerox.com\:1521;SID\=DOCSH;InitializationString=(alter session set NLS_SORT=CANADIAN_M)
Note: Please refer to the Oracle website at _http://www.oracle.com or documentation to obtain the most current information on Oracle. If necessary, contact the vendor directly for additional information on Oracle Linguistic Sort Order for other languages and locales.
5. Save the changes
6. Start DocuShare
To Change the Linguistic Sort Order in SQL:
Note: You must be a Database Administrator or Administrator to perform this solution
Note: SQL Server has a default of the locale of the Operating System.
To Change the COLATION of the database by running the ALTER database SQL statement.
ALTER DATABASE MyDatabase COLLATE <desired collation>
Note: Please refer to the Microsoft website at _http://www.microsoft.com or documentation to obtain the most current information on SQL Server collate names. If necessary, contact the vendor directly for additional information on SQL Collation Names.