i have database type varchar(100)
, value contains double quotes ""
, example:
tca cream 65 ml fc 24% “a z m”
i use sql server 2008.
when call data in web page ""
can't read.
the result looks like:
first thought font family not supported, tried many different font families:
html body div.popup_window_css div.popup_window_css_body { border: 1px solid black; border-width: 0px 1px 0px 1px; padding: 6px 6px 0px 6px; background: #dbdbba; width: 615px; font: 900 14px trebuchet ms, sans-serif, times new roman; }
but doesn't work...
you have escape quotes in html make work.
use javascript convert these quotes, have value:
var quotestring = mydbvalue.replace('"', """);
or try turn "
"
way like.
from comment:
success: function(data){ $("#pname").replace('"', """); $("#pname").html(data); }
must change into:
success: function(data){ escapeddata = data.dbvalue.replace('"', """); $("#pname").html(escapeddata); }
of course i'm not sure data
looks in code, should select right property i.e. dbvalue
in code.
Comments
Post a Comment