Reputation: 1
How can I decode these weird characters to readable Persian in sql server?
I'm using sql server to manage a .mdf database. The database content is supposed to be Persian. However what I get is only some weird characters. I've changed every windows setting related to language to Persian and still have the problem. Here you can see a screenshot of what a table looks like
Do I need a decoding algorithm or I'm just missing a basic configuration?
Upvotes: 0
Views: 513
Answers (1)
Reputation: 67291
Your screenshot looks like Sql Server Management Studio.
There is Extras - Options - Environment where you can select language and proper font.
But - in general - I would avoid languages depending on special characters for technical names.
I have no experience with this, but (just by feeling) I'd assume, that a database with persian object names will be a never ending source of troubles in future...
Persian content in NVARCHAR columns shouldn't be a problem though...
Upvotes: 2
Related Questions
- error on converting persian characters from excel to sql
- Searching Persian characters and words in SQL server with different encoding
- Persian character encoding in oracle database
- Persian character's issue in mysql database
- convert utf-8 string to Persian unicode
- How to insert Persian words into a SQL Server database?
- How can I use UTF-8 in SQL Statement?
- Insert persian characters in SQL database
- Russian characters encoding in SQL Server
- Troublesome Character in SQL Table?