March 2, 2013 at 12:28 pm
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?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy