Breaking News: Grepper is joining You.com. Read the official announcement!

How to insert Arabic characters into SQL database

Mappy Show answered on May 6, 2022 Popularity 8/10 Helpfulness 4/10

answer How to insert Arabic characters into SQL database

How to insert Arabic characters into SQL database

Comment

# For the field to be able to store unicode characters, 
# you have to use the type nvarchar (or other similar like ntext, nchar).

# To insert the unicode characters in the database you have to send 
# the text as unicode by using a parameter type like nvarchar / SqlDbType.NVarChar.

# (For completeness: if you are creating SQL dynamically (against common advice), 
# you put an N before a string literal to make it unicode. For example: 
 
insert into table (name) values (N'Pavan').)

Popularity 8/10 Helpfulness 4/10 Language sql

Source: stackoverflow.com

Tags: arabic database insert sql

Link to this answer
Share Copy Link