UTF-8 Format

pklcnu · Post by **pklcnu** » Wed Apr 28, 2010 11:09 am

Dear Experts

I am loading the UTF-8 format flat files in to oracle tables and all the files are loading fine including the special characters except one file.

I have the following warning message while loading it.

Column_Import_11,0: Invalid character(s) ([x80]) found converting string (code point(s): klant geeft aan dat [x80] per betaald ) from codepage UTF-8 to Unicode, substituting.

Please help why is this warning coming up......

Many Thanks

ray.wurlod · Post by **ray.wurlod** » Wed Apr 28, 2010 4:59 pm

0x80 represents null internally in DataStage. Can you learn what this particular byte is being used for in the troublesome file?

pklcnu · Post by **pklcnu** » Wed Apr 28, 2010 11:46 pm

ray.wurlod wrote:0x80 represents null internally in DataStage. Can you learn what this particular byte is being used for in the troublesome file? ...

Thanks for the reply Ray, I exactly I should check it ?

ray.wurlod · Post by **ray.wurlod** » Thu Apr 29, 2010 12:12 am

No idea, because it's not my file.

pklcnu · Post by **pklcnu** » Thu Apr 29, 2010 1:08 am

ray.wurlod wrote:No idea, because it's not my file. ...

I found on the IBM website that it is bogus warning......i am heading in the direction of applying the patch as suggested by IBM in the following link.

http://www-01.ibm.com/support/docview.w ... wg1JR32253

Will update this post once i get input from IBM support.

Thanks for your help Ray.

chulett · Post by **chulett** » Thu Apr 29, 2010 5:40 am

No, you found "a" bogus warning issue, don't assume that means any invalid characters message must therefor be bogus. I would wager they meant that specific message, with those characters and integer metadata in play.

We'll be here when you come back.