Hi.
I am working on editing Buddhist texts and the MSSQL database helps me with this. I created tables with Polish and English dictionaries - they work well. However, I cannot import Pali words, probably due to the wrong code page.
Has anyone had a similar problem?
my code:
BULK INSERT [dbo].[slownik_palijski]
FROM ‘I:\pali.txt’
WITH
(
CODEPAGE=‘65001’,
FIRSTROW = 1,
–FIELDTERMINATOR = ‘,’, --CSV field delimiter
ROWTERMINATOR = ‘0x0a’, --Use to shift the control to next row
TABLOCK
)
and errors:
Msg 4832, Level 16, State 1, Line 45
Bulk load: An unexpected end of file was encountered in the data file.
Msg 7399, Level 16, State 1, Line 45
The OLE DB provider “BULK” for linked server “(null)” reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 45
Cannot fetch a row from OLE DB provider “BULK” for linked server “(null)”.