i had a shell script writing a xml file. I need to use "& # 163;" instead of "£", and replace others characters like: > to > , and so on.. Anyone know how to convert the character automatically? my script as below:


do
# GET FEED REC
SQL2="SELECT A.*, B.subject FROM feed_details A, feed_category B where A.status=0 and A.feedCategoryId=B.id limit 1"
#FEED="$(/usr/bin/mysql -N -u${DB_USER} -p${DB_PWD} -h${DB_HOST} ${DB_NAME} -e "${SQL2}")"
FEED="$(/usr/bin/mysql -N -u${DB_USER} -p${DB_PWD} ${DB_NAME} -e "${SQL2}")"
arrayDB=($FEED)

echo " <item>"
echo " <guid isPermaLink="false">SMS${arrayDB[$dbId]}-${DB_CUR_DATE}</guid>"
echo " <pubDate>${arrayDB[$dbPubishDate]}</pubDate>"
echo " <dc:subject>${arrayDB[$dbSubject]}</dc:subject>"
echo " <dc:description>SMS</dc:description>"
echo " <dc:type>Text</dc:type>"
echo " <dc:format>text/plain</dc:format>"
echo " <description>${arrayDB[$dbDescription]}</description>"
echo " </item>"

# UPDATE STATUS TO 1 (DONE)
SQL3="UPDATE feed_details SET status=1 WHERE id='${arrayDB[dbId]}' limit 1"
done


I am trying to convert the value from DB to xml character set, £--> "& # 163;"
Anyone can help???