SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 How can i specify the RTL direction for a column i
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Hossein
Starting Member

Iran
3 Posts

Posted - 03/02/2013 :  14:47:43  Show Profile  Reply with Quote
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 rtl content it gets ugly.
How can i get this right?
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000