Storing HTML code into SQL 2005 by using asp.net2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,
i wabt to insert a rich text format(*.rtf) file type with a picture into sql
database. i have done this issue by converting rtf into web page and save the
html code into sql server table. but the problem is when the web page has a
picture, the picture could not be shown. whats the problem?
 
Probably you are trying to store binary data, the picture, into a string
field and it contains characters that cannot be stored.

Maybe you should encode the picture into Base64 when you store it and then
decode when you want to use it.

Rick
 
pmn,

HTML cannot contain images, only references in the format of url tags to
pictures.

Cor
 
Hi,

Why / how are you converting RTF to HTML?

If you simply want to insert RTF source into the database, then use the
varchar or text data type for your column.
 
hi Rick, what i want to do is to isert a formateted text into sql. you can
imagin that i want to design a news website and the news could be every
things including text and pictures.
 
Back
Top