Djaber Meghar
Djaber Meghar

Reputation: 37

How to store Arabic characters on SQL DATABASE

I'm trying to make a website in which the user has to submit his name written in arabic, but in the database it looks something like "?????" , i made a search to solve the problem, i knew that i had to change the collation, but the problem is there no collation named "Arabic CI.... Etc" and there is no collation supports arabic... Also there is no nvarchar type... Is there any other way?

Upvotes: 1

Views: 114

Answers (1)

Shohreh Mortazavi
Shohreh Mortazavi

Reputation: 224

use N before your text:

N'سلام'

Upvotes: 2

Related Questions