-2

I have a table on my server called players which has column for first name and second name for the player but it my ssms server or my table doesn't read arabic letter and it changes the letters to. ???? (question mark) how can I make it read arabic letters

a_horse_with_no_name
  • 497,550
  • 91
  • 775
  • 843
Nwenar Abbas
  • 1

1 Answers1

0

In order to store non-english character, you would need to ensure your table can store utf-8 characters.

For same, when you create a table, you can set COLLATE

CREATE TABLE dbo.MyTable2 (
VARCHAR(50)
COLLATE Latin1_General_100_CI_AI_SC_UTF8);

More details: https://techcommunity.microsoft.com/t5/sql-server/introducing-utf-8-support-for-sql-server/ba-p/734928

Let me know if this helps.

Hussain Bohra
  • 877
  • 8
  • 15
  • *"In order to store non-english character, you would need to ensure your table can store utf-8 characters."* So you're saying that prior to SQL Server 2019 you couldn't? That's not true... – Larnu May 22 '21 at 20:47
  • Prior to 2019, SQL server has data types like NVarchar, NText etc (normal data type prefixed by N) which makes it Unicode compatible, but with the utf-8 support, using utf-8 is recommended now – Hussain Bohra May 23 '21 at 00:41
  • *"but with the utf-8 support, using utf-8 is recommended noq"* can you cite that? I would suggest it is not the recommendation; just an option. – Larnu May 23 '21 at 07:46
  • yeah it helps but i have already created the table so how can I update it please? – Nwenar Abbas May 25 '21 at 14:40