please note that I want to change the character '°' to
'& # 1 7 6' . ( without spaces )
Appu1982
Last Activity: Nov 8 '17, 11:24 AM
Joined: Nov 6 '17
Location:
-
Convert a varchar column in a db2 table to UTF-8
Hi,
I am having a db2 table which stores an XML data in a column of type varchar(32000). This contains several data like -> 'def N° abcd'. I want to check this column value for a row for the character '°' and convert it to '°'.
There are several charcetrs like this in the XML that needs to be converted. I am using a PL/1 DB2 program.
Please suggest a best approach.
No activity results to display
Leave a comment: