Actually, I want to save the license plate with Persian characters as below.
Example:
"12 (Persian Character) 423"
//First, two digits, then a Persian character followed by three digits.
But the problem is stored in SQL Server as shown below:
Data type for plaque:
What needs to be done in order I want to save and then read it?
Looking to save Unicode? Use the N prefix: INSERT INTO YourTable(yourcolumn) VALUES (N'yourstring')
Update: Trickery to store the value without getting reversed:
Create Table #tbl
(
val nVarChar(25)
)
insert into #tbl select Reverse((Reverse(N'12')+N'ص' + Reverse(N'423')))
Select * From #tbl