Saturday, March 11, 2006

&lt; != <

Darn, I just noticed that PlanetMySQL renders the literal equivalents of the &lt; and &gt; entity references I use to display XML in my previous blog entry "Importing XML data into MySQL using ExtractData()".

This means the xml fragments, but also the calls to MySQL XML functions won't show at all, or only partially (only the text content seem to be rendered).

I wonder how other people've solved that...

No comments:

SAP HANA Trick: DISTINCT STRING_AGG

Nowadays, many SQL implementations offer some form of aggregate string concatenation function. Being an aggregate function, it has the effe...