Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re: Mildly OT: Excel Order Forms -> XML -> MySQL -> HTML with unicode

by iburrell (Chaplain)
on Oct 06, 2004 at 16:39 UTC ( [id://397070] : note . print w/replies, xml ) Need Help??


in reply to Mildly OT: Excel Order Forms -> XML -> MySQL -> HTML with unicode

You don't need to have character entities in the XML. XML parsers should handle Unicode characters in the document just fine. The encoding="UTF-8" signals the encoding of the XML to all XML parsers. On the web you will need to set the Content-Type correctly; including the charset if possible is a good idea.
  • Comment on Re: Mildly OT: Excel Order Forms -> XML -> MySQL -> HTML with unicode

Replies are listed 'Best First'.
Re^2: Mildly OT: Excel Order Forms -> XML -> MySQL -> HTML with unicode
by davis (Vicar) on Oct 22, 2004 at 10:01 UTC

    Thanks, this solved my problem, after some playing (and forgetting about the problem for a bit). When I was viewing the page containing the Unicode characters, I viewed "Page Information" in my browser. Turns out Apache was specifying the charset as ISO-8859-1 in its HTTP Response, and this was overriding my browser's interpretation of the Meta tags. A quick

    $q->charset("UTF-8");
    in my display code, and everything is fixed.
    Cheers!


    davis
    It wasn't easy to juggle a pregnant wife and a troubled child, but somehow I managed to fit in eight hours of TV a day.
Re^2: Mildly OT: Excel Order Forms -> XML -> MySQL -> HTML with unicode
by Anonymous Monk on Oct 07, 2004 at 14:32 UTC