عندي قاعدة بيانات على sql server لكن فية تيبل البيانات التي فية تظهر على شكل نجوم***

Question

الحقول التي في التيبل بعضها تظهر البيانات وبعض الحقول تظهر نجوم كيف اجعل النجوم تختفي تظهر البيانات مثل باقي الحقول وشكراً

Answer 1

If you are using sql server make sure your column is nvarchar and insert data with N'data'.

https://stackoverflow.com/questions/8089907/sql-server-convert-varchar-to-another-collation-code-page-to-fix-character-e

Answer 2

What database management system are you using?

Here you can find more information on Sql server :

https://docs.microsoft.com/en-us/sql/t-sql/functions/unicode-transact-sql?view=sql-server-2017

Answer 3

Sql server 2014

Answer 4

Ok. I'm not sure what exactly is the problem, but I guess that's some encoding issue.
Maybe you should change collation if you are trying to display Arabic characters. Also, make sure to read about Unicode from the previous post.

Answer 5

ممكن توظح اكثر