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..