Monday 15 March 2010

mysql - Special characters appearing in HTML format -



mysql - Special characters appearing in HTML format -

i have legacy application developed in perl, apache , mysql.

some of sections in application display html codes character. problem isolated next characters on keyboard:

semicolon comma quotation marks less symbol greater symbol

the table stores info storing info itself. table charset=latin1.

the application using

<meta charset="utf-8" />

in html rendering.

my question "how solve issue"?

should making changes db charset ? ( have multiple places in application broken , multiple tables used in various sections ) should making changes in perl db connection? ( looks best place handle issue mutual module uses db interaction ) module decode/encode special characters.

any other suggestions?

doesn't db charset issue, looks html escaping issue. appears have pre-escaped character entity references in info values unescaped html browser, within text box , escaped. how rendered? ajax code isn't rendering escapes?

https://en.wikipedia.org/wiki/list_of_xml_and_html_character_entity_references#character_entity_references_in_html

html mysql perl browser

No comments:

Post a Comment