Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

How to insert Arabic characters into SQL database

# 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').)
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #How #insert #Arabic #characters #SQL #database
ADD COMMENT
Topic
Name
1+4 =