henrique
Frequent Visitor.
301 views

Ampersand in JDBC Driver with SQL Server

JDBC Driver with SQL Server:

I have a field => X VARCHAR (100) COLLATE SQL_Latin1_General_CP1_CI_AS.
It contains a commercial character (&) in its contents.
In the input xml tags, this is replaced by "& amp;".
I do not want this replacement.
How to solve this?
Labels (1)
0 Likes
2 Replies
Knowledge Partner
Knowledge Partner

Re: Ampersand in JDBC Driver with SQL Server

henriquecorrea;2494576 wrote:
JDBC Driver with SQL Server:

I have a field => X VARCHAR (100) COLLATE SQL_Latin1_General_CP1_CI_AS.
It contains a commercial character (&) in its contents.
In the input xml tags, this is replaced by "& amp;".
I do not want this replacement.
How to solve this?


Trace of an event being processed through the Input Transform, if that's where it happens, would be helpful.
0 Likes
Knowledge Partner
Knowledge Partner

Re: Ampersand in JDBC Driver with SQL Server

henriquecorrea wrote:

> I have a field => X VARCHAR (100) COLLATE SQL_Latin1_General_CP1_CI_AS.
> It contains a commercial character (&) in its contents.
> In the input xml tags, this is replaced by "& amp;".
> I do not want this replacement.
> How to solve this?


Since & is a meta character in XML used to escape other meta characters (and
itself) in text nodes and attribute values, this seems unavoidable. IDM should
convert it back to & when used in variables, tests and tokens or finally
written to IDV.
What do you see in IDV when you map the field without further processing to an
attribute, e.g. "description"? If you end up with & in IDV, something's
weird and as David already mentioned, a level 3 trace would be required to
understand the issue.

--
http://www.is4it.de/en/solution/identity-access-management/

(If you find this post helpful, please click on the star below.)
______________________________________________
https://www.is4it.de/identity-access-management
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.