How to Bulk insert Hindi Text in SQL Server -
i have .text file in way
केस रेयाज अन्सारी सय्यद शेबाज सय्यद गफ्फर
i want make bulk insert
when inserting using bulk command
bulk insert [dbo].[test_enrollment2] 'c:\test\test2.txt'
table shows value this
केस रेयाज अन्सारी सय्यद शेबाज सय्यद गफ्फर
while making entry using insert command
insert table (column name) values(n'केस रेयाज अन्सारी ')
it shows proper please suggest
it not possible write insert command because have more 5carore value
my column type nvarchar(200)
bulk insert [dbo].[test_enrollment2] 'c:\test\test2.txt' (fieldterminator = '","') - see more at: http://www.sqlteam.com/article/using-bulk-insert-to-load-a-text-file#sthash.2zsf5t8q.dpuf
you don't have delimiter in data sample data see.
Comments
Post a Comment