How can i specify the RTL direction for a column in SQL Server?

• Coderx7

  Right there with Babe

  Points: 792

  More actions

  March 2, 2013 at 12:28 pm

  #274742

  Is there a way in SQL Server , so that i can specify the rtl direction for a column ?

  Currently i have a query like this :

  SELECT IDSource, IDAviculture, NumberOfReserve, TotalMoney , Name + '(' + Description + ')' AS Descrition, Date

  FROM dbo.tblReserve

  WHERE (Sell = 1)

  The data are in Farsi and thus right to left.The problem is unless it is not rtl, it doesn't show the information in correct form.For example the following text needs to be right to left in order for سلام to get inside parentheses

  > علی (سلام)

  IDSource IDAviculture NumberOfReserve TotalMoney Name + '(' + Description + ')' AS Descrition Date

  12 5 1500 3000 علی (توضیحات)

  13 4 700 2500 مینا(تست )

  I Expected to be like

  IDSource IDAviculture NumberOfReserve TotalMoney Name + '(' + Description + ')' AS Descrition Date

  12 5 1500 3000 علی (توضیحات) س

  13 4 700 2500 مینا (تست ) س

  Please note that the editor here doesn't support `RTL` either , so basically it wont show the text correctly , so i had to put an extra letter (س) so that it shows it correctly .

  Basically what i wrote above can be translated into English as:

  Name + '(' + Description + ')'

  Ali (Description)

  Mina (Test)

  in English because of being LTR it is fine but when it comes to the rtlcontent it gets ugly.

  How can i get this right?