SQL converts ' to " in content output

Hi



I am trying to find the easiest way to make sure that all reserved chars are output correctly when rendering content to the web.



Characters like ' and bullets etc. are either changed or removed completely.



e.g content is entered as "the boy's bicycle" and outputed as

"the boy"s bicycle"



Please help



Thank

If you are using ASP, you can always use the replace function. or you can just use a ' for the tags instead of a "

e.g.



input type='text' value='%oRS("whatever")%'



Otherwise you can replace the stuff when you select them from sequal

e.g.