Enabling this option will force all data to be resorted using the client codpage.  Without this setting, the results of certain queries will be sorted in the codepage of the dataserver when the index used matches order by clause of the SQL statement.  Enabling this option will result in slower performance, but data will be consistently ordered using the client codepage.

 

FORCECLIENTSORT= 1 

 

Default = 0.

 

Environments: Client, Windows, Unix

Configuration Manager: CONNX Settings; Current Key = CONNX; Key Value/Value Name =  FORCECLIENTSORT

 

Unix Registry Setting: CONNX.FORCECLIENTSORT