SQL & PL/SQL

Dear Friends,

In our application, User copying some data from a document and pasting in a field "Comments".

If that data consists anything like bullets,arrows of word document. It is inserting some junk characters into database like below.

• Analysys
• Do
• Now
• When
• As
• We

don’t know how much he love sthe testing’I am not crazyh’


I AM ‘USER’ 



 Uu
 Yy
 tt


Now user asking to remove all those Junk characters from Comments Column. Please help!

Edited by: San Reddy on May 31, 2010 6:09 PM

Edited by: San Reddy on May 31, 2010 6:18 PM