Re: 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");` [download] 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.	[reply] [d/l]
Re^2: Mildly OT: Excel Order Forms -> XML -> MySQL -> HTML with unicode by Anonymous Monk on Oct 07, 2004 at 14:32 UTC
On the web you will need to set the Content-Type correctly; including the charset if possible is a good idea. WaSP Asks the W3C - Specifying Character Encoding	[reply]