in my case user can store arabic or english values in the same column actually in the same fieldPlease let me know how are you doing this, because I never saw a case where that's possible.
my question is (is (sql_latin_general_cp1_ci_No it can't. Can support all occidental languages as English, German, Spanish, French, Italian, Portuguese, Swedish, etc... but not oriental languages as Arabic, Chinese, Japanese, Korean, ...as) can support arabic and english?)
-if yes, why data stored like ????? when store arabicThat's a proof that it can't store Arabic characters.
-if no,when i tried to change database colltion to Arabic_CI_AS give me the following errorThat's because Arabic collation isn't compatible with Latin_General collation so SQL Server can't perform the necessary conversion.
EXEC [Product].[SP_AddProductCategory] N'تيشيرت'
Open in new window