Hi All,
Using DBLOOKUP i am fetching a CLOB data from database. This CLOB data contains some special characters which, after fetching from DB gettign converted to some other characters. The field where i am fetching is set as data language UTF-8 but when i am trying with certain special characters its coming along with some other invalid characters.
For eg:- If i am the clob data containing special charater © this is gettng converted to Ã'©.
similarly these charaters ýöÅôÉ€óò& are gettign converted to ýöÅôÉâ'¬Ã³Ã²
Any help appreciated..
regards,
Sidhu