Hi, As you may know, we have still some problems with true sorting order in Persian (Farsi) language. If you are using SQL Server 6.x you can define your own sort order in an external file. But unfortunately SQL server7 and 2000 sort by internal hash tables. You may use one of the following methods: 1. using ORDER BY command. 2. using sort property of the UI control (i.e. List box or Combo box) you can use SetLocale function in the very begining of your source code. 3. mixing method 1 and 2.
Result of all methods are as the same and all of them have problem but if you want to have true order you should use your own code. Arash Rezaiizadeh Mehrsoft Group. ----- Original Message ----- From: "Roozbeh Pournader" <[EMAIL PROTECTED]> To: "mohammad mohebbi" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 2:58 PM Subject: Re: [farsiweb]ask for unicode > On Mon, 20 May 2002, mohammad mohebbi wrote: > > > i store farsi names in a field of SQL server table, if i sort this field > > , will sorted by farsi order? > > As far as I know, the answer is no. Arash Rezaiizadeh and me are trying to > convince Microsoft to add a Persian sorting table, but before that, you > should sort Persian with your own code. > > roozbeh > > _______________________________________________ > FarsiWeb mailing list > [EMAIL PROTECTED] > http://lists.sharif.edu/mailman/listinfo/farsiweb > > _______________________________________________ FarsiWeb mailing list [EMAIL PROTECTED] http://lists.sharif.edu/mailman/listinfo/farsiweb
