I have installed sql server with Arabic collation and I was able to create a table with two fields that has nvarchar datatype and I was able to insert data into that table.
I did the same thing with default sql server , when I insert data into same table structure, it worked, but when I change the datatype to varchar I get ???? value instead of the actual value.
So I came to a conclusion, which may be wrong, so you can correct me if it is not right.
I can use default sql server set up to insert arabic entry provided that I am using nvarchar or vcahr datatype. If this is correct then , what is the added feature when I install sql server with arabic collaction if I can insert data into the table with default setting.
I hope I did not confused you, and thanks alot for your advice and guidance.
Regards,
Al
I did the same thing with default sql server , when I insert data into same table structure, it worked, but when I change the datatype to varchar I get ???? value instead of the actual value.
So I came to a conclusion, which may be wrong, so you can correct me if it is not right.
I can use default sql server set up to insert arabic entry provided that I am using nvarchar or vcahr datatype. If this is correct then , what is the added feature when I install sql server with arabic collaction if I can insert data into the table with default setting.
I hope I did not confused you, and thanks alot for your advice and guidance.
Regards,
Al
