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

Popular posts from this blog

android - Get AccessToken using signpost OAuth without opening a browser (Two legged Oauth) -

org.mockito.exceptions.misusing.InvalidUseOfMatchersException: mockito -

google shop client API returns 400 bad request error while adding an item -