mysql - Bulk load data conversion error from csv file to SQL -

i have problem inserting data csv file sql database. don't why there error when replace unwanted characters. should able insert got error.

"msg 4864, level 16, state 1, line 1 bulk load data conversion error (type mismatch or invalid character specified codepage) row 1, column 13 (creditlimit)."

this create table:

create table customers(     customernumber integer not null,     customername varchar(50) not null,     customerlastname varchar(50) not null,     customerfirstname varchar(50) not null,     phone varchar(50) not null,     addressline1 varchar(50) not null,     addressline2 varchar(50) null,     city varchar(50) not null,     [state] varchar(50) null,     postalcode varchar(15) not null,     country varchar(50) not null,     salesrepemployeenumber integer not null,     creditlimit double precision not null     primary key(customernumber) ); 

this first few lines of csv file:

first line- 103,atelier graphique,schmitt,carine ,40.32.2555,54 rue royale,null,nantes,null,44000,france,1370,21000

second line- 112,signal gift stores,king,sue,7025551838,8489 strong st.,null,las vegas,nv,83030,usa,1166,71800

im not sure why there error can please me?

i think it's because rowterminator wrong ... should use \n not /n ...