Problem with Extented Ascii data

General
Enthusiast

Problem with Extented Ascii data

Hi ,

I have a column defined as Unicode and data it contains is like " ä " which is part of extended ascii characters.

but when i read the data from a ascii connection it fetches proper data , but when i read from and utf8 connection data is converted to " ä ".

Can someone explain why is this happening and what should be done to resolve it.

Thanks,
Vinay.
4 REPLIES

Re: Problem with Extented Ascii data

Use a ASCII connection to read and write a LATIN column, and use a UTF8 to read and write a UNICODE column.
Enthusiast

Re: Problem with Extented Ascii data

but my concern here is when i read a unicode ( as mentioned above) column using utf8 connection it is not showing proper data. :(
Teradata Employee

Re: Problem with Extented Ascii data

Hi,

Can you please mention from which tool you are trying to read data?

Regards,

MAC
Enthusiast

Re: Problem with Extented Ascii data

Hi ,

I am using Informatica ETL tool for reading from Table and writing to a file. Relational connection is UTF8 and target file is also UTF8.

I have also tried using bteq for exporting data to a file, i am having the same issue :(

Regards,
Vinay.