Hello,

I tried to same in PB, (2022 1892)

String ls_one, ls_two
ls_one = '#›@Š%&ž#•'
ls_two = ls_one
Messagebox('1', 'One : ' + ls_one + '~r~nTwo : ' + ls_two)

I get the above result.   I think I could not understand the issue well enough.

Happiness Always
BKR Sivaprakash

Hi Durai,

The idea of PBDOM is to easily handle the XML format. So it does the encoding of special characters like "&" for you.

If you have "a & b" in your XML it will return it as "a & b" to you because it is exactly what it means.

(If you want to get  "a & b" it must be in xml as "a & b" or as CDATA section.)

AFAIK you can't get plain (unencoded) XML text with PBDOM.

You could try Microsofts MSXML Activex. It has more options and I think you can also get the xml representation of a node.

HTH,

René

Hi,

Where / how is your UTF-8 data stored? Where do you get it from and how.

You can store data in a blob variable and then use the String() function, specifying the Encoding that you want. See the help on the String() function.

Not sure if that helps you.

If you can, give us some code so we understand better what it is that you want to do exactly.

regards,

MiguelL

I think everyone is missing the point here. "&" isn't a UTF-8 specific encoding, it's specific to HTML/XML because the & symbol gets translated. When the data gets extracted from the incoming string it's converting the string encoded version of an '&' back to it's normal string version.

Here's a Wiki link for special XML characters.

Hi MiguelL,

In my application, we consume one web service using HTTPClient and the response we receive back as xml format. Content-Type: text/xml; charset=utf-8.

The response xml have & wherever the & present. Example, #›@Š%&ž#• is one of the encrypted response from the web service.
I need to save the same value to one of the variable and try to use for my further validations.

Whenever i save the above into one of the string data type
variable then by default amp; is not saving whenever & comes. It means, when I save #›@Š%&ž#• to string data type variable
then it save as #›@Š%&ž#• (i.e. without amp;)

Is there any way to save this #›@Š%&ž#• as same value and reuse the variable ?

Regards,

Durai

Hello,

Can you try URLEncode and URLDecode ?

Happiness Always
BKR Sivaprakash

Hello,

If I understand the issue correctly, you want to save the value (#›@Š%&ž#•) into a string data type.  Am I right?

I tried saving the value through the following query

Update table1
Set field1 = '#›@Š%&ž#•'
Where key = 'kljth3df'

I could store it.  My database is PostgreSQL 15 and I tried the above query through PG Admin4 6.16.   

Here is the screen shot after storing the value in the database.  

Correct me If my understanding is wrong.

Happiness Always
BKR Sivaprakash

Hi Sivaprakash,

Thanks for your response. It's fine if I hard code the value and store from one variable to another variable. how i can store '&' along with '&' through below GetChileElement and gettext()

lo_client = Create httpClient
lpbdom_Builder = CREATE PBDOM_BUILDER
lo_client.SetRequestHeader("Content-Type", "text/xml; charset=utf-8")
lo_client.sendrequest('POST',ls_url,ls_body)
lo_client.GetResponseBody(ls_data)

lpbdom_Doc = lpbdom_Builder.BuildFromString(ls_data)
ls_username = lpbdom_Doc.GetRootElement().&
GetChildElement("Body", "soap","http://schemas.xmlsoap.org/soap/envelope/").&
GetChildElement("GetEncryptionResponse","","http://url_name/").&
GetChildElement("GetEncryptionResult","","http://url_name/").gettext()