Description gets truncated on server :confused:
-
I m working on a c# and sql server based application... I m fetching data from csv file and saving it's record One by one in to the database. there is a column colled Description in my csv file as well as Sql server table. In Sql i have given the data type "text" for the description column... And it's working fine on my local machine but on server description gets truncated... I have checked the csv file There is no comma in description Everything is same StoredProcedure...DLLs... I m not getting this... :confused: If any one has any idea abt this pls help me out... thanx & regards Anuj Kamthan Software Developer Solversa Technologies, Pune - 411007, India. http://www.solversa.com
-
I m working on a c# and sql server based application... I m fetching data from csv file and saving it's record One by one in to the database. there is a column colled Description in my csv file as well as Sql server table. In Sql i have given the data type "text" for the description column... And it's working fine on my local machine but on server description gets truncated... I have checked the csv file There is no comma in description Everything is same StoredProcedure...DLLs... I m not getting this... :confused: If any one has any idea abt this pls help me out... thanx & regards Anuj Kamthan Software Developer Solversa Technologies, Pune - 411007, India. http://www.solversa.com
-
Try to change column type of Description from text to varchar(255)//varchar (increase by yourself) _____________________ Proud to be Albanian _____________________
Nop Body, I have tried this also... Same result working fine on local machine but not on server. Anuj Kamthan Software Developer Solversa Technologies, Pune - 411007, India. http://www.solversa.com
-
I m working on a c# and sql server based application... I m fetching data from csv file and saving it's record One by one in to the database. there is a column colled Description in my csv file as well as Sql server table. In Sql i have given the data type "text" for the description column... And it's working fine on my local machine but on server description gets truncated... I have checked the csv file There is no comma in description Everything is same StoredProcedure...DLLs... I m not getting this... :confused: If any one has any idea abt this pls help me out... thanx & regards Anuj Kamthan Software Developer Solversa Technologies, Pune - 411007, India. http://www.solversa.com