Loading

How to convert a text File into ntext (sql datat type) in c#

Praveen Kumar

Hello Everyone,
I would like to save a file into the MS SQL database as ntext datatype.
Please help...how can i convert any file to ntext format , same time i want to save in database as well as retrive also,so that i can get the file again back from database without any corruption in file.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vishal Jadav16y ago
Hi buddy,
Its little bit simple to save unicode data to Nchar/Ntext/Nvarchar datatyped field in Ms Sql .
Simply Put N infront of your field when u save to DB.

like insert into DBname values N' Your Text ';
That's it..
I hope it will work coz currently i m also doing the same with multilingual project.

Keep in Touch buddy...