Problem With BULK INSERT ASCII File Into Nvarchar Column

Hi,
I have a problem with BULK INSERT. I created the following table:




Code Snippetcreate table Test
(id char(4), name nvarchar(16), last char(1))



I am trying to bulk insert data from ASCII (not unicode) file with only two rows:
0011First name
0018Second name



Since it is a fixed length file, I am using the following format file:




Code Snippet
8.0
3
1 SQLCHAR 0 4 "" 1 ID HEBREW_CI_AS
2 SQLCHAR 0 16 "" 2 NAME HEBREW_CI_AS
3 SQLCHAR 0 0 "
" 3 Last HEBREW_CI_AS





With bcp utility everything works just fine!



Code Snippet
bcp Demo.dbo.test in c: est -T -f c: est.fmt





But when I use BULK INSERT in the following form:



Code Snippet
BULK INSERT Test FROM 'c:Test'
WITH
(
FORMATFILE='c:Test.fmt',
CODEPAGE='OEM'
);



I am getting error
Server: Msg 4863, Level 16, State 1, Line 1
Bulk insert data conversion error (truncation) for row 1, column 2 (name).

Now, one interesting thing: if I change the name field from nvarchar to varchar, it is working with BULK INSERT as well.
Can anybody explain what is going on here?

I am using MS SQL 2000 and MSDE

Thanks in advance,
Eugene.