Visual LANSA Forum

I have a field in a LANSA defined file that is a CLOB. When I do an SQL in an SQLRPGLE program to retrieve the data the character '&' returns '&'.
How do I stop this? What causes this? Are there other characters this will happen to?

Is the CLOB data formatted as HTML, XMLor just plain text ?

HTML.

That's why the ampersand ( & ) is &

That's also why, for example, less than ( < ) and greater than ( > ) characters would be stored as &lt; and &gt;

See https://www.htmlhelp.com/reference/html ... ecial.html for an example of some of the most common characters.

I don't think you can stop this because it's correct HTML.

To understand why this happens try this incorrect HTML fragment:

<div> I like use a lot of <div> tags in my HTML pages </div>

It needs to be coded as

<div> I like use a lot of &lt;div&gt; tags in my HTML pages </div>

to work.