Read Arabic text file into Sql server 2008 table

*  Save your text file as "unuicode"
*  use ntext, nvarchar, nchar as Columns Datatypes

* The DB collation should be Arabic_100_CI_AS

use this query:


use DBname
BULK INSERT  dbo.TableName FROM 'c:\TextFileName.txt' 
WITH (    

      FIELDTERMINATOR = '\t',
      ROWTERMINATOR = 'q'    
);

\t: is the delimiter between columns

q: is the delimiter between rows