Toad World® Forums

XMLTYPe issuesin grid - 12.9.0.20

This is a regression bug, select containing xmltype in output is displayed with some “chinese” characters

It’s a known issue. The best workaround is to cast to a CLOB, like this. You have to include the table alias or you will get an error. This conversion is done automatically in the Data tab of the Schema Browser, but you have to add it manually in the Editor.

SELECT

T.NUMBERCOL, T.XMLCOL.GetClobVal() as XMLCOL

FROM TABLE_WITH_XML T