problem:storing rtf formatted data into sql

[askhar516]

Hi,all,may be this is a simple question, but i can't fix it. i can't store rtf format of any unicode string or chinese string into sql database by using sql statement. The unicode string or chinese string is from the richtextbox, i used "rtfData=RichTextBox.Rtf" and tried to insert rtfData int sql database, but i can't. is there any special character i have to deal with in the rtf formatted data?please help,thanks!

[i i i]

please can you explain on a little more that on front end you are using any application like vb , vc or what and which approach are you using to store the data in data base data set , objects or what

Best Of Regards, SOFTDEV Sad like books with torn pages, sad like unfinished stories ...

[askhar516]

thanks for the reply,i used the vb.net ,i fixed the problem by doubling the single quote.