Search
 
SCRIPT & CODE EXAMPLE
 

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').)
Comment

PREVIOUS NEXT
Code Example
Sql :: insert array into mysql column 
Sql :: psql no such file or directory 
Sql :: to_date postgresql 
Sql :: command to give readonly access to a postgres sql user 
Sql :: ms sql mac 
Sql :: show details of table postgres 
Sql :: create table from existing table in sql 
Sql :: query to delete a database in mysql 
Sql :: multiple count with where clause sql 
Sql :: add column in table 
Sql :: find mysql password 
Sql :: How to import CSV file into a MySQL table 
Sql :: try catch sql 
Sql :: sql drop table 
Sql :: auto increment in postgresql 
Sql :: using SQL in rails migration 
Sql :: sql where contains part of string 
Sql :: postgresql database url 
Sql :: temp tables in sql server 
Sql :: reset postgres table index to next max value 
Sql :: How to search for a String in all Columns in all tables in SQL Server Database 
Sql :: sql compiler online 
Sql :: mysql command prompt date insert format 
Sql :: sql date function 
Sql :: r write csv without index 
Sql :: sql arithmetic operators 
Sql :: sql insert into 
Sql :: oracle drop type if exists 
Sql :: between date in sql server 
Sql :: mysql trigger 
ADD CONTENT
Topic
Content
Source link
Name
8+8 =