422,734 Members | 1,335 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 422,734 IT Pros & Developers. It's quick & easy.

Convert a varchar column in a db2 table to UTF-8

P: 2
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.
Nov 6 '17 #1
Share this Question
Share on Google+
1 Reply


P: 2
please note that I want to change the character '' to
'& # 1 7 6' . ( without spaces )
Nov 6 '17 #2

Post your reply

Sign in to post your reply or Sign up for a free account.