Wednesday, 29 June 2016

How to insert the Unicode characters in the table ?

If you want to insert the Unicode characters such as Arabic,Japanese & Chinese etc in the table we need to follow the below steps.

In the below example i tried to insert the Arabic characters in the ArabicTable.


After inserting the record if we try to select the data, then ArabicName column will be saved as ?????.


If you want to insert the Unicode characters in the table, then you need to insert the value using 'N' as shown below.


After executing the above statement, then the data will be saved as expected.


To save the Unicode characters in the column, the column should be of Nvarchar data type.

No comments:

Post a Comment