Originally posted by: Sidhumohan

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

Originally posted by: Bhoju

apply leaveprint() function

Originally posted by: Sidhumohan

The LEAVEPRINT function removes all non-printable characters from a text item.

But i want excat these characters and dont want to remove those.

Originally posted by: pcp

Try changing the data language to UTF-16 or LATIN-1 in the field where you are fetching the CLOB data.

Thanks, Phil

Originally posted by: Sidhumohan

UTF-16 not workign..have to try with latin-1...I have this same issue while inserting these characters to the database too....the encoding used in the type tree is UTF-8...Still not working...Any one please suggest..

Originally posted by: DJ2610

You can use iso-8859-1 it supports all the special characters

Thanks,

Dilip

Originally posted by: paul.brett

Turn on the input card backup.  This will give you a 'raw' version of the input data from the adapter before any changes are applied by the input Typetree.  If this data is correct, then it is your Typetree at fault.

If the input backup data is wrong, then you need to look at adjusting your NLS_LANG variable to match that used by the DB server.