Search code examples
sql-serverright-to-leftnvarchar

SQL Server save brackets in nvarchar for Arabic language

I am using sql server 2008 R2 to store my data. I have a datatable named postMaster where I save all the posts in my organization. All posts have to be described in english and arabic. My problem is with the arabic description of the post

My data table structure as follows:

enter image description here

and a sample record will look as follows:

enter image description here

As you can see from the picture, the Arabic description mixes up the brackets and when I display data in datagridview it would look the save way it is saved!

Is there away to make these brackets be properly saved as in english way?

Solution

  • It's because the postDescAr is not displaying texts in a RTL format. The data is saved correctly, but not displayed correctly. It depends on from where you query the data.