insert special characters into ms acess database ?

[rajivkadam420]

how to insert special characters into ms acess database along with text below is my example

<!--#include file="common.asp"-->
<!--#include file="header.asp"-->
<%
CheckAdminLogin
if request("submit")="Save" then
OpenDataBase conn
newshead=request("newshead")
newsdes=request("newsdes")

if newshead="" or newsdes="" then er=er & "<font color='red' size=4>Headline Cannot be blank</font>"
if er="" then
sql="insert into news(news_titile,news_description) values('" & cstr(newshead) & "' , '" & cstr(newsdes) & "')" 
'sql="insert into news(news_titile,news_description) values('" & Cstr(newshead) & "','" & Cstr(newsdes) & "' ) "
conn.execute sql
response.write("<font color='green' size=4>News and Top News is Stored Sucessfully</font>")
response.Redirect("addheadlineimage.asp")
else 
response.write er
end if 
end if
if request("submit")="addmore images to previous headlines" then
response.Redirect("listnewsheadline.asp")
end if

%>
<form name="addleftnews" action="addleftnews.asp" method="post">
<table align="left"  >
<tr>
<td><a href="listnewsheadline.asp">Add More Images to Previous Headlines</a></td>
</tr>
</table>

<table align="center">
<tr><td> HeadLine </td><td><textarea name="newshead" cols="50" rows="2"></textarea></td></tr>
<tr><td> Description</td><td><textarea name="newsdes" cols="50" rows="15"></textarea></td></tr>
<tr><td></td>
<td align="center" bgcolor="#FFFFFF">
<input type="submit" name="submit" value="Save">
</td>

</tr>
</table>

</form>

[jhardman]

which special characters are giving you trouble? Is it that you are saving HTML encoding?

Jared