OCONV

thumsup9 · Post by **thumsup9** » Wed Aug 16, 2006 3:00 pm

Some rows are getting dropped before inserted into the target table with the below warning.

LimitedCust..tmfCust.InsertCust: DSD.BCIPut call to OCONV failed.
Column: Description, NLS mapname: MS1252, Column data (after conversion): Clothes issue: 62082-04BOL?edition # 82 of 200 leaking , Column data (in hex, before conversion) 504E41205061696E742049737375653A202036323038322D3034424F4CC29765646974696F6E2023203832206F6620323030206C65616B696E6720

-----When I ran it with NLS set to NONE all rows are processed.
The Description column is Nvarchar (on source) to Varchar(on Target)

Any ideas appreciated,

Thanks,

DeepakCorning · Post by **DeepakCorning** » Wed Aug 16, 2006 3:45 pm

As far as my understanding is this error may be because of the special characters in the data which the defined NLS is not able to take care of. Is this the actual data or it is some what changed in the warning message ( I see question marks in there)

thumsup9 · Post by **thumsup9** » Wed Aug 16, 2006 3:47 pm

I could find a similar question as mine on the forum, but its not giving an answer though..

http://dsxchange.com/viewtopic.php?t=10 ... 4b0352855d

please let me know if you need more inputs..

thumsup9 · Post by **thumsup9** » Wed Aug 16, 2006 3:52 pm

Yes DeepakCorning

couple of the source values in 'Description' column that got dropped are

Clothes Issue: 62082-04BOL?edition # 82 of 200 leaking
XL Chassis: fork locks ?falling out",

Thanks

DeepakCorning · Post by **DeepakCorning** » Wed Aug 16, 2006 4:08 pm

Is this the actual data in your source ??

Clothes Issue: 62082-04BOL?edition # 82 of 200 leaking
XL Chassis: fork locks ?falling out",

thumsup9 · Post by **thumsup9** » Thu Aug 17, 2006 8:07 am

Yes , This is how my source data looks like. What is the best way to handle this. Does this mean that the NLS map MS1252 is not able to handle the data or is there anything else I need to check here before coming to a conclusion.

Appreciate your comments..

Thanks

ray.wurlod · Post by **ray.wurlod** » Thu Aug 17, 2006 8:41 am

Can you leave the map set to NONE and process the hex data with

Code: Select all

Iconv(InLink.HexString, "MX0C")

to see what you get?

thumsup9 · Post by **thumsup9** » Thu Aug 17, 2006 9:08 am

Hi Ray,

all the rows are processed but the the target description column is empty.

thumsup9 · Post by **thumsup9** » Thu Aug 17, 2006 11:37 am

Hi ,

The source rows that are getting dropped have a special character in it.This wont allow me to paste it as it is.Its a square block between the words. Does this help?

When I paste it looks like below here


Thanks