blob image read and write to txt file...

rasi · Post by **rasi** » Mon Jan 20, 2003 5:31 am

Hi,

I am reading a blob image from SQL Server 2000. This image file has English and Non-English characters in it. When I read the image and write it as file it works for English. But when it reads Non-English Characters and writes to file the file is empty. Any idea what is this issue. I am using Iconv(MXOC) function to convert binary data into file.

Thanks
Rasi

ray.wurlod · Post by **ray.wurlod** » Mon Jan 20, 2003 4:11 pm

Are you running DataStage with NLS enabled? If so, try conversion with "MU0C" rather than "MX0C". Also, what character map have you specified for reading the BLOB? It may be that the non-English characters - or, for that matter, any byte or byte sequence that is outside the printable range - has caused the problem.
DataStage does not claim to support binary data types.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518