html - Make double quotes from database value appear properly -


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:

enter image description here

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 " &quot 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